System Dates in Copied Sheet
Hello,
I will be using gathered data from a sheet to create two new sheets (I am separating an existing process into two new ones). I copied the sheet using Save as New to create the second sheet and I will be modifying the existing one.
My challenge is all the system dates - Created Date, Modified Date - changed to today in the copied sheet. This affects my formula in the Age of Request column.
Is there a way that I can keep the System Dates so I don't need to create extra columns for the past dates and change the Age of Request formula?
Thank you!
Best Answer
-
@Ketch Pablo I think I found a solution for you. Follow these steps:
1- Save SheetA as SheetB --> During this process, uncheck the options regarding Data).
2- Or, delete all rows in SheetB.
3- In SheetA, create a checkbox column called CopyRowNow.
4- In SheetA, create an automation Move rows to another sheet when specified criteria are met:
4a- Trigger: When rows are changed
4b- When: CopyRowNow changes to CHECKED
4c- Run Workflow: When triggered
4d- In the Move Rows block, select SheetB --> you can also change this action to Copy Rows to test first.
4e- Save the automation
5- In SheetA, select the checkbox of CopyRowNow column for a few rows and save the sheet.
6- Open SheetB, note that the creation date has been copied over but the modified date.
Let me know if this worked for you 😃
Answers
-
@Ketch Pablo I think I found a solution for you. Follow these steps:
1- Save SheetA as SheetB --> During this process, uncheck the options regarding Data).
2- Or, delete all rows in SheetB.
3- In SheetA, create a checkbox column called CopyRowNow.
4- In SheetA, create an automation Move rows to another sheet when specified criteria are met:
4a- Trigger: When rows are changed
4b- When: CopyRowNow changes to CHECKED
4c- Run Workflow: When triggered
4d- In the Move Rows block, select SheetB --> you can also change this action to Copy Rows to test first.
4e- Save the automation
5- In SheetA, select the checkbox of CopyRowNow column for a few rows and save the sheet.
6- Open SheetB, note that the creation date has been copied over but the modified date.
Let me know if this worked for you 😃
-
Hi @Anelise Wilhelm ,
This makes so much sense! I will give it a try and let you know if I encounter any kinks.
Thank you so much.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives