Automated Printing of a Dashboard - or workaround to take a snapshot before month carries over

Hey all,


Hoping someone may be able to assist... We have dashboards that show the current live data and that automatically tick over as the months do and all the data changes.


It is working fabulously, except we want to be able to take a snapshot the moment before the month ticks over. That is at 11:59pm on the last day of the month.


As our main users are tucked up in bed at this time, we are hoping there is an automated way to do this?


Once it hits midnight all the data changes to be the new month. I could make the data have one day lag, but the business wants to be able to see the data as it currently stands, not the previous days data.


I have my fingers crossed someone has a work around or an idea to help us :)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!