Multi-Select Formulas

lesmickin ✭✭
edited 12/09/19 in Formulas and Functions

First.....Im so happy the Multi-select feature is now available - so thank you.

This leads me needing some assistance.  I have played around with a LOT Of different formulas trying o find a way to capture this information.

I am needing help with trying to find a formula  to do a count of selected options that were placed in that field.

I have tried the Countifs formula (as well as a bunch of others0, but it will only count if the item selected was entered by itself and not in conjunction with others. or just gives me errors


Field 1: EPP, Driver, Faucet

Field 2: EPP, Faucet, Home

Field 3: EPP

Count of EPP only comes to 1 and not 3



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!