Dashboard Chart to Match Current User Report - Multiple Project Owners


I have a follow-up to a previous question answered here - https://community.smartsheet.com/discussion/comment/263483

Some of our projects have two owners (two contacts in the requestor cell) so I'd like the charts to reflect the project on each person's dashboard. Currently, I have 1 project in progress and the requestors are John Doe and Jane Doe. When I check the John Doe and Jane Doe rows in the metrics sheet, the 'In Progress' column shows a value of 0.

Can you advise on how I can adjust the formula in my metrics sheet to account for projects with 2 contacts in the requestor column?

Current formula -

=COUNTIFS({Project Lead}, $[Project Lead]@row, {Project Status}, [In Progress]:[In Progress])

Best Answer