Add Actual start and completion date based on status column

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

 

 

 

Screen 1.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!