Dropdown Multi select - ~If formula

Jose da Silva

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.

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