Creating a report by task owner and RAG status

Options

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

Answers