Trying to use SUMIF to Sum one column but only of the items in another column

Options

I am trying to get the SUM of SaaS Value if the value in the Backlog Status column is Active Backlog.


Tried this and I am getting unparseable

SUMIF([Backlog Status]:[Backlog Status],”Inactive Backlog”, [SaaS Value]:[SaaS Value])

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!