Formula needed: Multi drop down select column to output value in another column
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
Check out the Formula Handbook template!