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.
Formula Help please
I need a formula that will do the following please...
In the field "How Many" they will select from a drop down list
I will run the formula in the Cleaning Fee column.
Depending on which one they select, I need values to go into the Cleaning Fee column
So for 1-200 the value would be 150.00
201-400 would be 300.00, 401-600 would be 450.00 and >600 would be 600.00.