Counting Employees in Assigned To Column

Derek Snow

Hello,

I can count how many times somebody's name is in the Assigned To Column, but when I have multiple people assigned to one project, my formula does not count either person. Does anybody know what I am missing?

Formula is =COUNTIFS({Assigned To}, [Primary Column]@row, {Status}, "Backlog")

Thank you,

Derek

Yuan Wong

Hi @Derek Snow ,

your current: Formula is =COUNTIFS({Assigned To}, [Primary Column]@row, {Status}, "Backlog")

try using: CONTAINS(criteria, @cell)

also take out the [ ]

so correct format Formula is

=COUNTIFS({Assigned To}, CONTAINS(Primary Column@row,@cell), {Status}, "Backlog")

OR

=COUNTIFS({Assigned To}, CONTAINS(Primary Column1,@cell), {Status}, "Backlog")

Yuan Wong

sorry correction**...you have a SPACE between Primary -and- Column. so you do need the [ ]

try Formula

=COUNTIFS({Assigned To}, CONTAINS([Primary Column]@row,@cell), {Status}, "Backlog")

OR

=COUNTIFS({Assigned To}, CONTAINS([Primary Column]1,@cell), {Status}, "Backlog")

Derek Snow

It turns out this is the correct formula. It needs to use HAS instead of CONTAINS when counting contacts.

=COUNTIFS({Status}, "Backlog", {Assigned To}, HAS(@cell, [Primary Column]@row))