Count users assigned from sheet while using Edit reference to another sheet

David Clunie

Hi All

I have Smartsheet that collates data for a dashboard.

One of the areas is trying to get the number of Assigned users based on criteria. Example how many sub-projects have not started and give me the count.

I can get this to work if only one user is in a cell, but if there is more, it fails and generally only picks up the first assigned user.

1)COUNTIFS

2) Reference another sheet to gather Assigned To

3) Match Users name on sheet

4) Reference another sheet to gather Status

5)Cross reference Status on sheet

=COUNTIFS({DP Assigned to}, [Assigned To]@row, {DP Status}, $[Not Started]$1)

Paul Newcome

Try working in a HAS function like so...

=COUNTIFS({DP Assigned to}, HAS(@cell, [Assigned To]@row), {DP Status}, $[Not Started]$1)

Paul Newcome

Try working in a HAS function like so...

=COUNTIFS({DP Assigned to}, HAS(@cell, [Assigned To]@row), {DP Status}, $[Not Started]$1)

David Clunie

Perfect, thank you very much

Paul Newcome

Happy to help. 👍️