"Persistent", one-time date function

RockyJim
edited 12/09/19 in Smartsheet Basics

I'd like to see a function like "TODAY()", or cell behavior that supports it, that executes only once when an event is triggered so that the date result that never changes. 

My use case is a Card view Kanban board with status states: Ready, Dev, Test, Deploy, Done, and matching columns for their start dates, e.g. Dev Start.  I'd like to track the dates that the status state is changes; e.g. "=IF([email protected] = "Dev", TODAY())". Current and understandable behavior is that when the status changes to Dev my date cell captures that date, but when the status changes to Test, the Dev Start column goes blank and the Test Start column gets the date.

I want the value that is oroiginally set in the date column to be persistent.

I can see the same feature to capture baseline dates for Start and End dates in schedules.. 

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Unfortunately SS does not support time/date stamps for specific actions. The dates have to be manually entered for them to be fixed dates.

    thinkspi.com

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

    Hi Jim,

    Unfortunately, it's not possible to do it natively in Smartsheet at the moment, but it's a great idea!

    Please submit an Enhancement Request when you have a moment.

    It sounds to me that something probably could be set up with the help of a third-party solution like Zapier or similar.

    Would that work?

    Happy Holidays & Happy New Year!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.