Multiple conditional formula involving checkboxes ticking to prompt addition of fields

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

Hi,

I want to create formula to sum 5 $ fields, however only want them to be summed when they have actually been paid. To know if it's been paid we have made a Paid checkbox.

From this I was going to make a formula to do this for us, however have got stuck.

If([Payment 1 Paid]<>ture,[Payment 1 amount]

There are 5 payment amounts and 5 Payments paid fields, how can I keep building this formula to add them all up.

Thanks

Ps. If there is better way to get the same result, suggestions welcomed.

Photo of Scott

Scott

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Try this:



IF([Payment 1 Paid],[Payment 1 amount],0)

+

IF([Payment 2 Paid],[Payment 2 amount],0)


+

IF([Payment 3 Paid],[Payment 3 amount],0)


+


IF([Payment 4 Paid],[Payment 4 amount],0)


+

IF([Payment 5 Paid],[Payment 5 amount],0)
Photo of Scott

Scott

  • 0 Points
Top Answer Mark. Can always rely on the QB Coaches to find the right solution. Thank you