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
rornelasrornelas 

when checkboxes are selected add time to formula field

I have the formula field that based on the picklist selection it will populate the appropiate time. Using the picklist is limited and would like to use checkboxes so that way for each checbox checked it will calculate the time that way i.e checkbox 1 10min, checbox 2 60min = 70min. Hopefully this makes sense. Here is the formula field with picklist im working with.
  
Case( Stop_Complexity__c,
"Easy",15,
"Moderate",30,
"Difficult",90,
null)

 
Best Answer chosen by rornelas
sfdcFanBoysfdcFanBoy

Try this

IF (checkbox1__c, 15, 0) +  IF (checkbox2__c, 30, 0) + IF (checkbox3__c, 90, 0)

Thanks,
Manish
https://sfdcfanboy.com
Mark the solution as Answer, if its works for you

All Answers

sfdcFanBoysfdcFanBoy

Try this

IF (checkbox1__c, 15, 0) +  IF (checkbox2__c, 30, 0) + IF (checkbox3__c, 90, 0)

Thanks,
Manish
https://sfdcfanboy.com
Mark the solution as Answer, if its works for you
This was selected as the best answer
rornelasrornelas
Hey SfdcFanBoy,

Thanks it worked! I posted another question if you're interested in asnwering
https://developer.salesforce.com/forums/ForumsMain?id=9060G000000IC7hQAG