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
inlikecinlikec 

Can you create multiple "true/false" Custom Fields in an Opportunity Record which true equals a certain value and false equals a value in order to get a total value calculated?

Looking to have multiple "true/false" custom fields in an Opp record. 

If someone answers "true" have that equal 10, if someone answers "false" have that equal zero.  Then have a custom field at the bottom that adds up the values to come up with a total "score". Possible?

Andrew GAndrew G
Hi

You could try a formula field something like:
  
IF( Check_One__c ,10,0) +
IF( Check_Two__c ,10,0) +
IF( Check_Three__c ,10,0)
where the Check_One__c etc. are custom check boxes.

Regards
Andrew