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

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.


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)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!