I'd like to add a formula field that will calculate a total based on the true/false status of several other fields.We have dozens of these true/false fields so I'm hoping I can do this without adding a new formula field for each option.
I'm hoping for something like:
if([option1]=true, + 25, 0)
if([option2]=true, + 15, 0)
So, if the both the fields [option1] and [option2] are true, this formula field would display 40.
Is this possible?