Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How can I write a formula to summarize in parent row summaries in child rows?
Column is entitled Status and is a drop down list with the following selections:
Not Started
In Progress
Delayed
Cancelled
Complete
I have a formula in each child row to summarize grandparent rows:
="Not Started (" + COUNTIF(CHILDREN(), "Not Started") + "), In Progress (" + COUNTIF(CHILDREN(), "In Progress") + "), Delayed (" + COUNTIF(CHILDREN(), "Delayed") + ") Cancelled (" + COUNTIF(CHILDREN(), "Cancelled") + ") Completed (" + COUNTIF(CHILDREN(), "Completed") + ")"
This gives me the following summary in each child row:
Not Started (0), In Progress (2), Delayed (1) Cancelled (0) Completed (0)
For the upper most parent row how do I summarize these summaries in the child rows so I have the same output as above but it is counting the summries of each child row?
Appreciate anyone's input/help!!!
Comments
-
Susan,
have you checked out these posts?
https://community.smartsheet.com/discussion/counting-all-siblings-below-master-parent
-
Thanks Tim, I will check it out!
-
The new @cell reference (in 2016-08-06) release allows this formula:
=COUNTIF(Status13:Status25, @cell = "Not Started")
in the grandparent (or great grandparent) to determine the number of Not Started's in each row - regardless of heirarchy status.
It requires abandoning the usefulness of the CHILDREN() function, and thus having to know the size of the data, but I'm still testing to find the solution.
Something tells me there is something in the new release that will solve this.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives