Countifs + Contains/Find + Multiple Criteria

Hi,


I have a column that is a multi-select with contact options and I'm trying to create a formula that Counts the amount of times a person's name shows up in that column AND also matches the entity name selected in another column (single select).

I have two separate formulas but I can't seem to combine them the right way... help?

=COUNTIFS({Recruiter}, (FIND("Jane Doe", @cell) > 0), {Division}, "Entity Name")

=COUNTIFS({Recruiter}, "Jane Doe", {Division}, "Entity Name")

Answers

  • Mike Raposo
    Mike Raposo ✭✭✭✭

    Hi,

    So you're actually super close, I believe the issue is that you need to use the CONTAINS() function instead of FIND() in the first formula you listed above:

    =COUNTIFS({Recruiter}, CONTAINS("Jane Doe", @cell), {Division}, "Entity Name")

    Hope this helps! Let me know if you have any questions.

    Best,

    Mike

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!