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!

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.