COUNTIFS/CONTAINS FUNCTION

RySols
RySols ✭✭
edited 12/09/19 in Formulas and Functions

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").

 

Test Sheet.JPG

«134

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!