Sum of each Dropdown Option Selected Formula Help

Laura

Any Suggestions on the simplest way to formulate this? 

 

• Dropdown Column - "Part Status"
• Dropdown Options - 

        "Delayed"

        "Not Started"

        "In Progress"

        "Warehouse"

        "Shipped"

 

I want to show a total sheet sum for EACH Dropdown Option shown. Part Status is only selected on the Parent Rows.

Rows 4-287 with 30 Parent Rows. 

Thanks so much!

Shaine Greenwood

Hi Laura,

It mainly depends on where you want to put these totals.

If you want to put them in a parent-most row (one with no parents of its own), then you can use a formula like =COUNTIF(CHILDREN(), "Delayed") which will only count direct children.

Otherwise, you can use a formula like =COUNTIF(ANCESTORS(), "Delayed")

Both CHILDREN and ANCESTORS allow you to reference a cell to count its children or parents.

More info on CHILDREN: https://help.smartsheet.com/function/children

ANCESTORS: https://help.smartsheet.com/function/ancestors