I have a restricted dropdown menu that based on the choice made, a value is added in helper column

The restricted dropdown options are




The value for P1a is 2.0, the value for P2a is 1.5, and no value if the dropdown is left blank or N/A is selected.

I have been using the following formula when the values were the same (both 1.5) =IF(OR(ISBLANK([Wednesday, 1/10/24 Opening Keynote 1:45-2:45 pm]@row), [Wednesday, 1/10/24 Opening Keynote 1:45-2:45 pm]@row = "N/A"), "", 1.5)

but since each choice has a unique value, this formula will not work

I tried using =IF(OR(CONTAINS("P1b", [Wednesday, 1/10/24 Pre-Conference 9:30-11:30 am]@row), 1.5), (CONTAINS("P1a", [Wednesday, 1/10/24 Pre-Conference 9:30-11:30 am]@row), 2.0) but I'm getting a syntax error.

I appreciate the help!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!