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:
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!!!