Counting a Specific Word in a Multi-Select Column



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!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!