IF Statement w/Drop-down Multi-select

Lisa Marie

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!

L_123

You cannot edit the dropdowns directly in the sheet via formulas. If your end users are using forms you can use form logic to have dynamic dropdowns. (form logic is at the bottom of the article I posted below)

https://help.smartsheet.com/learning-track/smartsheet-intermediate/forms

markkrebs

Lisa, are you still looking for an answer on this? I just did a formula that evaluates 2 columns and then populates the appropriate multi-select values:

=IF(AND([Column 1]@row = "Yes",Column 2@row = "Yes"), "QA Exception Request" + CHAR(10) + "Security Assessment Request", IF([Column 1]@row = "Yes", "QA Exception Request", IF([Column 2]@row = "Yes", "Security Assessment Request")))