Formula needed: Multi drop down select column to output value in another column

Hi All,

Any help with a formula? This is driving me nuts!

Basically what we're hoping is to be able to select multiple values within the "Rate_Card_Tactic_T4/T5 column", and output the dollar amount that is assigned to that tactic in "T4/T5 Cost - Email Blast" column.

This is as far as I've gotten... it works only if I assign one formula, but when I try to duplicate the formula for all of the drop down list options, the dollar amount will not output into the other column.

=IF(CONTAINS("Email Blast", [Rate_Card_Tactic_T4/T5]@row), 3500)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!