Function to retrieve count in a multi-select column
Options
Answers
-
I am trying this as well and keep getting "Unparseable". The column I am using is the Assigned To multiselect contact column. The formula I use is: =COUNTIFS([Assigned To]:[Assigned To], FIND("John Doe", @cell) > 0))
Is there anything else I can try?
-
@Marianne Pho Try removing one of the closing parenthesis from the end.
=COUNTIFS([Assigned To]:[Assigned To], FIND("John Doe", @cell) > 0)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!