Counting a Specific Word in a Multi-Select Column

Hello!

I am trying to count a center word in a column that has multi-select and it is just not working. This is what I have now:

=COUNTIFS({Lakeside Village Opening - Action Items Range 1}, [Primary Column]@row, {Coronavirus Unified Working Group - Action Range 1}, $[Column4]$7)


The [Primary Column]@row is the word that is in a multi-select column.


Thank you!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!