Dashboard Chart to Match Current User Report - Multiple Project Owners
Hello,
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
-
If you're looking for a value within a multi-select cell, you'll want to use the HAS function to see if that cell has that value.
Try this:
=COUNTIFS({Project Lead}, HAS(@cell, $[Project Lead]@row), {Project Status}, [In Progress]:[In Progress])
Let me know if this works for you!
Cheers,
Genevieve
Answers
-
If you're looking for a value within a multi-select cell, you'll want to use the HAS function to see if that cell has that value.
Try this:
=COUNTIFS({Project Lead}, HAS(@cell, $[Project Lead]@row), {Project Status}, [In Progress]:[In Progress])
Let me know if this works for you!
Cheers,
Genevieve
-
That worked - thanks so much, @Genevieve P!
-
No problem! Glad it worked for you 🙂