Auto Created Date - Historic Data
Hi,
Just started using Smartsheet and I've got to admit, I am impressed.
I have a form, when the user submits data in the form, the timestamp is captured for when it is created.
The problem is, I have existing data I want to copy in which gets deleted when I change the column to autonumber - Created Date.
Best solution I've found is create another column, hide it and use that as an autonumber if the date column is blank by using an ifblank formula.
I also tried =LEFT(AutoDate@row, LEN(AutoDate@row)) to capture the date in the column beside it, but it automatically converts to todays date when I convert the formula to the whole column, which I need for the form to capture when it was created.
Can anyone help please? Or have another solution?
Thank you for taking the time to read 😊
Best Answer
-
I hope you're well and safe!
Welcome to the Community and the wonderful world of Smartsheet!
Please have a look at my post below with a method I developed.
More info:
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
I hope you're well and safe!
Welcome to the Community and the wonderful world of Smartsheet!
Please have a look at my post below with a method I developed.
More info:
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you for the quick response @Andrée Starå, great help.
After countless tries, I ended up creating a copy of my original sheet which captures the all user inputted data (including the autonumber created date). I then set a trigger to move this data when it was created. In my second sheet, rows are populated at the bottom of the sheet and generates unique Row ID. I've kept my workflows the same on this second sheet and now it works perfectly.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!