Community

Hi, I need help for a simple formula.  I emailed Smartsheet support a month ago but never got an answer.

I want to total how much has been spent by budget type in a given year.  Example types are Gardening or Security.  Debit is the $ amount, and Year is 2019 in this case.

Columns are:   Type, Debit

1

I have two Nested IF formulas that work separately, but keep given me an "incorrect argument set"  error when I combine them.  The two formulas are:

=IF(OR([Current Status]1 = "Completed", [Current Status]1 = "Terminated"), "Blue", IF(AND(OR([Current Status]1 = "Planned", [Current Status]1 =