Year to Date Function

I'm trying to set up a formula to where I can calculate Year to Date metrics from last year but up until present day. Example if today is May 1st I want to compare Jan-May 1st 2019 to Jan-May 1st 2020, I can do this if it fixed but what I want to accomplish is it to run automatic like Today() function that is continuously going on based on today's date.

Answers

  • Hi John,

    Would you be able to provide us with a bit more detail? It would be helpful to see screen captures of your sheet(s) (but block out any sensitive data) with a description of the type of metrics you are looking to collect.

    If you already have a formula built that's working but in a static way, it would be useful to see that, too!

    You can use the TODAY function but specify "in the past number of days from Today"... so for example TODAY(-365) is 365 days ago. Therefore, you could say in a formula, look >= TODAY(-365) and also look <=TODAY() to have it calculate between these two dates.

    Cheers!

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!