Auto-Number/System Created Date

Options

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

Steve

Answers

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

    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!

    Best,

    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!

    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.