Auto-Number/System Created Date


I have imported quite a large excel file into smartsheets. One of the columns is filled with dates; however, going forward using Smart Sheets, we would like to use the Auto-Number/System Created Date for the column.

When I set the Auto-Number/System Created Date for the required column, all the historic dates previously entered in the spreadsheet vanish.

Is there anyway to retain this historic date information and use the Auto-Number/System Created Date going forward, as we are looking to self populate this from a form?

Many thanks



  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Steve Whitten

    You could add two so-called helper columns.

    Add one for the created date and another one for the date to show. 

    You'd then use a formula that checks if the imported formula is empty. It would use the created date and, otherwise, the imported ones.

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.