Add Actual start and completion date based on status column

jitendra.khatri102252

All,

 

I want to fill date column based on status column.

1) If status is  "In Progress" "Actual Date" is filled by today's date.

2) If status is "Completed" then "Completion date" is filled by today date.

For now I am using =IF(Status@row = "In Progress", TODAY(), "") same for completion date column.

But when change status from "In Progress" to "Completed" Actual Start date lost same happen on Completion date column when status is changed from "Completed " to "In Progress".

Thanks

 

 

 

Andrée Starå

Hi Jitendra,

Unfortunately, it's not possible at the moment to freeze the date when using the TODAY function, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

As a workaround, you could use the third-party integration called Zapier, which works perfectly for this scenario.

Is that an option for you?

Would that work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Abigail Darin

How exactly would Zapier work for this? I am looking through and it is used for workflow not integrating formulas as far as I can tell.

Andrée Starå

@Abigail Darin We'd check for an updated row and only continue if something is true and update the same row from the start with today's date.

Make sense?

Mike Wilday

You can now set a date based on another cell change using an automation workflow!

https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action?_ga=2.79950226.443393604.1609776795-1074882870.1602114816

Rob_PM

It doesn't work this record a date for cell-link

Mike Wilday

Correct. You can't record a date to a linked-cell and overwrite the cell on another sheet. HOWEVER, you could hide the cell-linked column and use a formula to replicate the hidden column cell value, and then overwrite that replicated value when something else changes on the sheet? OR are you talking about when a linked-cell changes it would trigger a record a date functionality?