Capture Sheet Data Metrics by Current Year and Quarter

Tony Fronza
Tony Fronza ✭✭✭✭
edited 09/08/23 in Formulas and Functions

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")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!