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

Laura ✭✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

Any Suggestions on the simplest way to formulate this? 


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


        "Not Started"

        "In Progress"




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!


This discussion has been closed.