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

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?