function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
pinky1pinky1 

Formula field for Account Object for checkbox

Hi,

When these 5 fields are marked "TRUE"
Field 1
Field 2
Field 3
Field 4
Field 5

Update "GOLD " to TRUE automatically.

These field are on Account object. Can someone help with the formula for this.
Raj VakatiRaj Vakati
You can't update the value with the formula and you need to use the workflow or process builder to update the checkbox based on those values 

Refer this link 

https://www.tutorialkart.com/salesforce/salesforce-workflow-actions-tasks-email-alert-field-update/
https://www.newfangled.com/creating-salesforce-workflow-rules/
 
pinky1pinky1
Is there anyway we can achieve it with formula field
Raj VakatiRaj Vakati
No .. These are the options 
  1. Workflow 
  2. Process Builder 
  3. Triggers 
Ajay K DubediAjay K Dubedi
Hi Pinky,

Firstly create (Field 1, Field 2, Field 3, Field 4, Field 5) fields datatype checkbox and then create a formula field (Field Label = Gold) > Select Formula Return Type checkbox and then write formula:
IF( (Field_1__c == TRUE && Field_2__c == TRUE && Field_3__c == TRUE && Field_4__c == TRUE && Field_5__c == TRUE), Field_1__c ,null )

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks,
Ajay Dubedi