Is a formula that adds amounts if field is true possible?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

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?

Photo of Taylor

Taylor

  • 52 Points

Posted 4 years ago

  • 0
  • 1
This is QuickBase, of course its possible :)

   If([option1], 25, 0)

+ if([option2],15, 0)

+ If([option3], 25, 0) + if([option4],15, 0)



Photo of Taylor

Taylor

  • 52 Points
Wonderful! I never doubted QB for a second!