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.
Answers
-
Hey @Ian MacFayden
Try this
=SUM(COLLECT(CHILDREN(Number@row), CHILDREN([approval status]@row), @cell = "Approved"))
-
=sumifs(children(number@row),children([approval status]@row),@cell = "Approved)
No need to add the collect and complicate things.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!