Autosave Copy of Sheet Daily

I'm wondering if there is a way for my sheet to autosave to a new sheet daily. What I would want is for it to create a copy of the sheet and save it to an archive folder everyday so I can see the changes that are made day to day. If there is a way to do this please help me out!! Thanks!!!

Find more posts tagged with

Account and User Management

Comments

Mick Jordan

Hi, I don't believe there is an "out of the box" way to achieve this ie by creating a copy each day automatically. There are however a few ways and techniques to understand what has changed and when etc. What is the nature of the sheet ie what kind of information is being updated and by whom?

Mick

megtimmi

It is a client status sheet that shows all the projects we are currently working on and it is being contributed to by a team of people.

Mick Jordan

ok, are you looking to just see what has changed or are you wanting to keep a detailed audit trail of any changes on any day?

I take it you have seen Change Highlighting which gives you a visual indication that cells have changed. Combined with the View Cell history feature you can then inspect what has changed and when. There is the Modified By and Modified Date system columns you could add in to also give you a view of when rows have been updated and by whom. You also have the notifications that can be set to let you know something has changed.

If however you want a detailed copy of the entire sheet essentially "backed-up" every day for closer scrutiny and audit purposes then one method would be to use eg Excel with a bit of custom code in and link it to Smartsheet using the data connector. A single spreadsheet could then be set (using a bit of custom code) to copy and save each day's row set so you end up having a day by day set of historical information.

Not sure if that helps?

Mick

JLE

You can schedule a daily export to your email

Open the sheet and look to

-file

-Send as attachment....

Sign in to join the conversation!

Quick Links

Trending discussions

Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
License Question
I already have a Smartsheet license with my company, but I was recently invited to collaborate on a sheet owned by another group within the same organization. When I accepted, I was told I need to upgrade in order to edit or contribute. Can you please explain why this is required? It seems unreasonable to need multiple…