Creating a report by task owner and RAG status

Ollie Cater

Hello Smart Sheet-ers,

I am fairly new to SmartSheet so excuse me if this is breathtakingly simple. I need to create a report of the following in dashboard. I assume from using Sheet Summary.

It needs to show Task Owner, then how many tasks that are RAG status red, yellow, green, blue.

I'm using the below columns:

So for example I'd like to see the person's name on the Y axis, then 4 x bars (red, yellow, green, blue) next to them in the dashboard.

So I need to know (I think) what formula to set up in the sheet summary to enable me to get that data into a report....

Thanks in advance!

Ollie

Paul Newcome

You would use a COUNTIFS.

=COUNTIFS({Source Sheet Assigned To Column}, "John Doe", {Source Sheet RYGB Column", "Red")

Then you would change "Red" to each of the different colors for each of your different counts.