How to copy a sheet without updating system generated columns Created By and Last Modified By?
I would like to back up a sheet that contains two system generated columns, Created By and Last Modified By, which currently are populated for all of the rows. When I tried saving the current sheet as a new sheet, all of my rows in the new sheet get messed up because many columns contain formulas that extract the data based on the Created By column, which Smartsheet automatically updates to my email address, rather than retaining the email addresses from the original sheet. I want to retain the original user's email addresses.
I also tried creating a template from the original sheet, which seems to work, but when I create a new sheet from the template, the same thing happens- the new sheet Created By column gets updated to my email address.
How do I back up or copy a sheet that contains system generated columns, which preserves those original values, and not have it updated to my email address?