Start and End Dates


As you can see from the picture below I have set up my columns to track certain dates. I work in construction so I have typed in what the GC gave me as a schedule. That is the Start and Finish and there duration. What i am trying to figure out is.

When Status changes to "In Progress" I would like for it to Record the actual day in start day and when it changes to to "Complete" End date will record actual day. Then "Duration" will then feel in as well.

Also the same for Delayed.

His this the best way to set it up or is there another way.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!