Drop Down Multi Select Formula
Good afternoon everyone. I am trying to figure out the best way to build an "IF" type formula from a multi select column. The formula I tried was: =IF([1. Line of Coverage]@row = "Voluntary Life/ADD", 1, 0). This would put a star in a column to illustrate that a document needs to be collected. This works as long as only "Voluntary Life/ADD" is selected from the Multi Select option, but if more options are selected it doesn't work. Is there a way to do more of something that would look like this: =IF([1. Line of Coverage]@row INCLUDES "Voluntary Life/ADD", 1, 0)?
I hope this makes sense
Answers
-
This makes a lot of sense, and there's a function that does exactly this! It's called the HAS function. This is specifically to see if a multi-select cell has a specific value.
Try this:
=IF(HAS([1. Line of Coverage]@row, "Voluntary Life/ADD"), 1, 0)
Let me know if this works!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Sorry this is a few years late, but how can I use that same HAS function (or I'm thinking CONTAIN might work better for my case) but include more than one selection from the multi-select column?
For example, I have a multi-select column with options of "Transfer Materials", "Collaboration with MDs", and "Desire for publication", and if someone selected "Transfer Materials" and "Collab with MDs" then I want the cell to return with "A Contract", if "Transfer Materials" and "Desire for publication" are selected then "B Contract", if all are selected then "C Contract", etc. if that makes sense?
-
Hi @Jayy S.
The easiest thing to do here would be to use a Change Cell workflow! You could add your criteria as conditional blocks to indicate when a cell should change value, based on what's selected in another cell:
If you want to stick with a formula, then you'll use an IF(AND scenario:
=IF(AND(HAS([Multi Select]@row, "Transfer Materials"), HAS([Multi Select]@row, "Collaboration with MDs")), "A Contract")
Cheers,
GenevieveNeed more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
I…forgot Automation exists. Oh wow. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!