Auto Created Date - Historic Data

Lewis Irving

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 😊

Andrée Starå

Hi @Lewis Irving

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: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

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!

Andrée Starå

Hi @Lewis Irving

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: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

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!

Lewis Irving

https://community.smartsheet.com/discussion/comment/297519#Comment_297519

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.

Andrée Starå

@Lewis Irving

Excellent!

You're more than welcome!