COUNTIFS/CONTAINS - When more than one name is in a cell on the reference sheet


=COUNTIFS({Linear Master Tracker - Series - Current Status}, NOT(OR(@cell = "Lost", @cell = "Passed", @cell = "Term Deal Completed/Expired", @cell = "Premiered")), {Linear Master Tracker - Series - Legal Exec}, CONTAINS($[Primary Column]@row, @cell))

In the below function, I am trying to get CONTAINS to work successfully. In {Linear Master Tracker - Series - Legal Exec} there can be multiple names from our Dropdown List, so when I reference the name of $[Primary Column]@row it is only coming up with data based off the first person listed in the referenced column.

I tried a CONTAINS function as well as FIND, but have not had success with either.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!