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.
Sum of each Dropdown Option Selected Formula Help
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!
Comments
-
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
