sumif with children

Hey everyone I am trying to set a formula that I believe should work but keep have an error returned. What I'm trying to achieve is in the box that says #unparseable I want it to sum the numbers below it only if the status column shows Approved. I want this to happen in perpetuity for any children rows that are added below the $400.00 row. I want my team to be able to use this without needing to worry about dragging the formula down. I was trying something like =sumif(children(approval status) @cell = approved

I know that's not complete but just for reference of what I've been trying.


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!