Start and End Dates

Ray Sanchez

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.

Bassam Khalil

Hi @Ray Sanchez

Hope you are fine, you can use Record date automation to do that check the following:

For start

For Finish

Bassam Khalil

Hi @Ray Sanchez

Hope you are fine, you can use Record date automation to do that check the following:

For start

For Finish

Ray Sanchez

Well that seemed a bit easy to figure out. hahaha Thank you for the help

Bassam Khalil

@Ray Sanchez 

Excellent that you can figure out now, i will be happy to help you anytime.  Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Bassam Khalil

Thanks @Ray Sanchez 

Ray Sanchez

I forgot to ask. The duration part. What is the best way to get the duration between the 2?