Drop Down Multi Select Formula

Amanda Jeske

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

Genevieve P.

Hi @Amanda Jeske

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