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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!