Changes since last week



Is there a way to show changes since last week to a 'date' column? I don't want to highlight the change, I want to be able to see if the date moved since last week and then calculate the number of days it moved (eg: +10)

I don't want to right click and view cell history either. I want to show a simple report/project with columns showing 'Last week's date' , 'This week's date' and 'Variance'.

Best Answer


  • Jas Condle

    Thanks Jennifer, it's a lot of manual work but it's a work around. Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!