I am trying to reference a multi-select drop down in an IF formula.

Options

I am create a formula where when two certain items from a mutli-select dropdown are selected, the formula will return 12.5, All other options or combination of options return 0.

I cannot get the reference right for having two options selected.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!