Dropdown Multi select - ~If formula

Hi all,

Been searching about this, but could not find anything so far. Hopefully you can help me.

I am just starting to make use of the multi select dropdown list.

So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a single column for each of the options from the dropdown. What i need to do is use a formula on each of those that basically applies the following logic -> "if this valie is ticked on the multi drop, then also tick it here"

How would that work?

Thanks in advance.

Find more posts tagged with

Manufacturing

Sheets

Healthcare

Formulas

Solution Center

Product Development

Project Management

Comments

Andrée Starå

Hi Jose,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Jose da Silva

Hi Andree,

See below the screenshots.

All i need is for the information that is ticked on the multidrop list to be duplicated to the individual columns (will have a column with tickbox for every option on the multidrop).

Do you know any good formula solution?

Paul Newcome

I would suggest using the CONTAINS function.

=IF(CONTAINS("insert text here", [Docs Checklist]@row), value if true)

Andrée Starå

Try something like this.

=IF(CONTAINS("NDA"; [Docs checklist]@row); 1)

The same version but with the below changes for your and others convenience.

=IF(CONTAINS("NDA", [Docs checklist]@row), 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Jose da Silva

Hi all, Thank you for your help.

It does work. Just a small correction on your formulas (just the p[lacement of a bracet):

=IF(CONTAINS("insert text",[Docs Checklist]@row),1)

Again, thanks all!!

Andrée Starå

Excellent!

Happy to help!

Mike Bumpus

Is this deprecated somehow with the addition of the Column Formula? Doing almost the exact same thing and getting #INCORRECT ARGUMENT SET

Genevieve P.

Hi @Mike Bumpus

That error has to do with the structure of your formula. The CONTAINS function first has the value you're searching for, then the range. After these are listed you want to close off the function: )

Try this:

=IF(CONTAINS("Video", [Actual LOB]@row), 1)

Now, since you're looking at a mutli-select column I would suggest using the HAS function instead, like so:

=IF(HAS([Actual LOB]@row, "Video"), 1)

Cheers!

Genevieve

Sign in to join the conversation!

Quick Links

Trending discussions

Issues with Attachments
Ok, I'm not new to Smartsheet but recently this simple automation has had me stumped. Pictured below is a simple automation we use to verify that an attachment has been added to each row in our system. IF attachment added or changed, THEN Change Cell Value. These worked beautifully all over our system until about a month…
Retrieving Cell info if another column falls between specific dates
Here is the formula I am trying and it's brining back #CIRCULAR REFERENCE =IF(AND([FPI Date]@row >= DATE({StartYr}, {StartMth}, {StartDy}), [Jan FPI]@row <= DATE({EndYr}, {EndMth}, {EndDay})), [eCOA_ID]@row , "")
Index/Match
I have two sheets that are capturing two different sets of data. Sheet 1 (Billable Mileage Log) is capturing projects that have been marked as needing mileage to be entered in a different platform. Sheet 2 is capturing mileage that's being entered via a Smartsheet form. On this sheet, I have two columns that have formulas.…