Capturing Date of Transaction



I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer".  I tried modified date but that field gets changed too often to accurately reflect the state.  Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's history.



  • Paul.Koetke
    Paul.Koetke ✭✭✭


    You can track when a cell was changed by using the Cell History function. However, there is no way to display this time stamp in a cell. What I would recommend instead would be to have a "Picked Up by Customer" date column. When the pickup is completed, you just select todays date instead of using the dropdown to show that it was picked up. 

    Let me know if this will work, otherwise happy to brainstorm different solutions. 

    Paul Koetke

    Upwork - Smartsheet Consultant

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

    Hi Mike,

    It's possible to do it with the help of a service like Zapier or similar. 

    Would that work?

    I hope this helps you!

    Have a fantastic day!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!