How to capture Actual Finish Time for a Cutover Task

edited 03/04/24 in Formulas and Functions

I have created a cutover Plan in Smartsheet and all tasks in the plan has these columns : Task, Duration, start Date and Start time, End Date and End time, Actual Start and Actual Time, Actual Finish Date and Actual Finish time.

I am able to calculate start and end dates based on duration but I’m only able to capture Actual start and Actual Finish dates based on workflow responses once the task gets triggered and submitted by the user as 100% done.

What is the way or formula to capture actual actual Finish time? Actual dates are captured using formulas but not actual end times

I want to use the Planned end time with actual end time to calculate variance and Reforcast the cutover plan end dates.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!