Adding data to a cell, rather than overwriting

Virginia
Virginia
edited 12/09/19 in Smartsheet Basics

Yaama all - has anyone found a way to add data to a cell, rather than update.  I know you can go in and edit, but instructing our executive team to do this is not going to work.  I tried a hidden column that added the 'new update' to the 'existing update' but this only works for the one update.  

Any assistance would be much appreciated!

Comments

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

    Hi Virginia,

    Not sure I follow!

    Do you want them to add new information and keep the historical data? Cell history will show all the old data, but I'm guessing that you want to show or calculate the historical data. Correct?

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    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.