Creating a report by task owner and RAG status
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!