Sum of values based on specific selections in drop down

edited 05/03/24 in Smartsheet Basics


I am trying to find a way to add a sum of “Projected Hours” based on different selections in a drop down column.

If Project 1 requires “Repair” I want projected hours to add 200, If Project 1 requires “Tune up” I wanted projected hours to add 100

If Project 1 requires “Repair” and “Tune up” I want it to add the 200 and 100 together in the projected hours. Being that the dropdown column listing the different requirements will have multiple options I want to be able to tie a value to whatever is selected and it spit out the total projected hours based off whatever requirements I select.
please help

Best Answer