unchanged conclusion date

Please can someone help me with a way to indicate the conclusion date of a task, automatically?  

Once I have a status set as finished, I need the current date to be "locked" on a cell and no changed/updated anymore. 




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

    Hi Guilherme,

    You would probably need to use a third-party solution like Zapier or similar for this.

    A possible workaround could be to lock the row automatically with Alerts & Actions.

    Would any of those options work?

    Have a fantastic week!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


    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.

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    You might consider changing up the process. We started using Actual Start and  Actual End date columns to determine whether a project was Not started, In Progress, or complete. We then applied a formula to the Status column and locked it down so that a status couldn't be changed manually and overwrite the formula. 

    =IF(AND(ISBLANK([Actual Finish]@row), ISBLANK([Actual Start]@row)), "Not Started", IF(ISDATE([Actual Finish]@row), "Complete", IF(ISDATE([Actual Start]@row), "In Progress")))