3 years of data, twice a year

I'm not sure this is even possible, but we want to display 3 years of data at year-end and then at mid-year. So, for the current data, we want the following: Dataset 1 = 7/1/2017-6/30/2020, Dataset 2 = 1/1/2018-12/31/2020. Ideally, this would be rolling, but if we have to manually update, that's fine too - I'm just not sure what formula to use for the dates.

Thanks!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!