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)

Forms | Smartsheet Learning Center

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

Smartsheet forms help accelerate execution and foster innovation by making it fast and easy to collect and act on data from anyone. Build your custom form in the user-friendly interface and add conditional logic to ensure the questions are relevant for each person who’ll fill it out. Then share the form so colleagues, contractors, clients, and others can easily submit information and files from their desktop and mobile devices, wherever they're located.

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")))