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 to add or subtract value based on item selected in drop down list
I would like to create a formula that can identify the item selceted in a drop down column and then automatically add a value based on the item selected in the drop down to the next cell.
Example if the item i selected from the dropdown list in column a was "deduct 10 points" I would like the formula to automatically deduct 10 points from the column b in the same row.
Any help is appreciated.