IF Statement w/Drop-down Multi-select

Hi folks,

I'm trying to create a formula focused on two columns (one a single-select drop-down and the second a multi-select drop-down). Based on the value in the single-select drop-down, I'd like the multi-select column to include multiple selections. My attempt at the formula is below:

=IF([Change Requested]@row = "New Part", "Element Update" AND "PSF Updates"

Any thoughts on how I could approach? Thanks so much!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!