@redtailfanschool In this video I demonstrate how you can use the 'switch' formula along with a 'query' to dynamically show data based on Quarters, Current Year, Last, year, all years, etc.
Example:
=SWITCH(B2,"Q1","1/1/"&B1,"Q2","4/1/"&B1,"Q3","7/1/"&B1,"Q4","10/1/"&B1,"Last Year","1/1/2023","This Year","1/1/2024","Total","1/1/2023")
Link to make a copy of the sheet:
https://docs.google.com/spreadsheets/...