=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.
