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


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!