COUNTIFS for prior period

Jess D
Jess D ✭✭
edited 02/09/24 in Formulas and Functions


I am looking to build a dashboard that displays prior month/quarter/year data. I have found ways to do this from a rolling perspective (Year (Today())-1) or specifying a year, such as (Year='2023')@Row, but none that appear to be scalable. I don't want to have to recreate any summary fields (with formulas)/reports/dash each new year and want the count within the period, not rolling relative to today. Is there a way to make the formula flexible do handle this?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!