Calculating Year to Date Totals


I would like to automate the calculation of weekly totals from the previous year (2019) so that I can compare them to current year (2020). In order to do this I need to automate the calculation of the previous year's total by the current week number. The screen shot shows the totals by week from 2019 with the week number on top. Your help is appreciated.




  • MCorbin
    MCorbin Overachievers Alumni

    Can you provide a screenshot of the sheet with the data in it? (blur out any PHI, naturally). I really only care about the headers. That will help with creating the formula....

  • Sam Lugiano
    Sam Lugiano ✭✭✭✭✭

    The YTD 2019 of 37,695 is just a SUM formula that I drag to current week. I would like to have it automatically calculate the current week. I tried using the IF(WEEKNUMBER(TODAY() before the SUM formula but couldn't get it to work. Please let me know if you cannot see the sheet below. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!