Request type by project
I'm having difficult trying to report on metrics that would outline the following:
Identify the number of request types by project
For example, if you have 5 projects, all named differently and 2 request types (new/existing) and you wanted to report in a sheet, to then carry over to a dashboard the number of requests by project.
project 1 - 2 new request types, 1 existing
project 2 - 1 existing, 0 new request types
Currently, I have a master sheet where data from a web form flows. I then have another "metrics" sheet where I have columns linked from the master sheet that I use formulas in. The formulas are populated in the metrics sheet and then linked to a master dashboard.
Any thoughts? Thank you for your support!
Help Article Resources
Check out the Formula Handbook template!