Formula: Search Column for multiple Titles and change dropdown

Options
HenryWong
HenryWong ✭✭
edited 05/03/23 in Formulas and Functions

Looking for a formula for:

If row 1 and column "Title" = 1, 2, 3, 4, 5

then

Change row 1, column "Access" = Yes

If false, leave it blank.

The "Access" column is currently set up as a drop down. Will this cause issues?


I am currently using under row 1 in column Access:

=IF([Title]@1="1", "2", "3","4","5", "Yes")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!