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!
Answers
-
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)
-
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")))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!