Capture Sheet Data Metrics by Current Year and Quarter
I am assisting our Marketing team with tracking social media statistics year over year broken out by quarter. I want to create a sheet summary field that captures metrics for the current year and a specific quarter to populate and auto-refresh on a dashboard to avoid manually modifying the metrics each quarter/year.
Is there a formula to find the current year and a specific quarter in the sheet data?
This is what I have so far but I'm receiving an Invalid Operation error:
=IF(AND(Year:Year = "2023", Quarter:Quarter = "1st"), [Total Account Posts]:[Total Account Posts], "0")
Help Article Resources
Check out the Formula Handbook template!