Dashboard Chart to Match Current User Report - Multiple Project Owners

Claire Owen-Schubnell

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])

Genevieve P.

Hi @Claire Owen-Schubnell

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

Genevieve P.

Hi @Claire Owen-Schubnell

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

Claire Owen-Schubnell

That worked - thanks so much, @Genevieve P!

Genevieve P.

No problem! Glad it worked for you 🙂