SUMIFS with OR (Sheet Summary)

Matthew Bertucci
Matthew Bertucci ✭✭✭✭

I'm trying to create a sheet summary formula

Sum up a Column -Total Save


Status column is "Orange"


Hierarchy Level 4 - SubDivision is "Solutions"

And either

FY23 into FY22 Pull Frwd (TM Notify) box is checked


Addition to Pull Frwd box is checked

=SUMIFS([Total Save]:[Total Save], OR([FY23 into FY22 Pull Frwd (TM Notify)] = 1, [Addition to Pull Frwd (TM Notify)] = 1), Status:Status, "Orange", [Hierarchy Level 4 - SubDivison]:[Hierarchy Level 4 - SubDivison], "Solutions"))

I keep getting unparseable result. Does is have to do with the fact that I'm in "sheet summary"? I've tried is many different ways and now I'm stuck. Any help would be much appreciated. πŸ˜€

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!