Hi All,
I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula:
=COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, "In Progress", {CORP ADMIN TEAM TASKS Range 2}, "Jane Doe")
However, it is only counting the name once it is the only option in the cell. So if Jane Doe appears alongside John Doe and Jack Doe in the multi-select cell, it will not count the name.
I tried this formula below, but it returns UNPARSEABLE:
=COUNTIFS (CONTAINS ("In Progress", [CORP ADMIN TEAM TASKS Range 1]:[CORP ADMIN TEAM TASKS Range 1]), "TRUE", "FALSE"), CONTAINS ("Jane Doe", [CORP ADMIN TEAM TASKS Range 2]:[CORP ADMIN TEAM TASKS Range 2]), "TRUE", "FALSE").
