How can I create a quarterly dashboard?
Currently I have an annual dashboard created by mostly pulling multiple reports that primarily uses sheet summary data.
How can I pull quarterly reports using the dates 10/1/22-1/31/23 to filter my reports? Keeping in mind that I can't filter by columns because I am using sheet summary to build my reports.
Here are screenshots:
I want to pull "Screening Date" between 10/1/22-1/31/23
Ideally we can filter by quarter on our report:
I am open to other ideas as well. This is just ONE report from the many reports that are pulling into a single dashboard. So if there's an easier way to filter by quarter on the dashboard itself, that would be the most ideal and efficient manner to do so. Screenshot of the dashboard below:
Help Article Resources
Check out the Formula Handbook template!