Sum if status is

Platform discussions Special workflows & use cases
1

Hi everyone,
I use this formula that works very well:

SUM(IF({Status1}=“Paid”, {Value1}, 0),IF({Status 2}=“Paid”, {Value2}, 0))

Sum only if the status matched with the amount is paid.

But now i need to sum both if the status is Paid but also if it is Down Payment or Payable

Thank you

2

@cromatina Might be a more efficient way to do this but this should work:

SUM(IF(OR({Status1}="Paid",{Status1}="Payable",{Status1}="Down Payment"),{Value1},0),IF(OR({Status2}="Paid",{Status2}="Payable",{Status2}="Down Payment"),{Value2},0))
1 Like