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?

Susan Cook
edited 12/09/19 in Archived 2016 Posts

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

This discussion has been closed.