Drop Down Multi Select Formula

Options

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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!