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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!