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
Help Article Resources
Categories
Check out the Formula Handbook template!