Auto Created Date - Historic Data



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!