Lead time formula/function

John Kelly

Hi,

I am trying to set up a procurement automation dictated by lead time. Currently I am using the Gantt, start date/duration/end date but kind of in reverse.

I have re-arranged the columns as follows, Lead Time - Days/Weeks (Duration), Critical Order Date (Start Date) and Program Date (End Date).

My procedure is to enter the program date first. Contractors enter the lead time and then the critical order date is automatically calculated. This in turn is used for other automated reminders etc.

Problem is, when I enter the program date, the lead time column defaults to 1d and the critical order date automatically adjusts for this. I have to manually delete the critical order date each time to set it up for automation. I am afraid of the human element in this and would like to have this simplified.

Can I have it so that the when the program date is entered that the lead time does not default to a time, rather it stays blank until it is manually populated?

Cheers

Harvey Mon

I suggest go to your project settings and remove it from your date range display as this automatically counts the intial day, and once they have entered their lead time then you can create another column for dates as your date range display in the Gantt View

I hope this will help you

Thanks Harvey

Harvey Mon

I suggest go to your project settings and remove it from your date range display as this automatically counts the intial day, and once they have entered their lead time then you can create another column for dates as your date range display in the Gantt View

I hope this will help you

Thanks Harvey

John Kelly

Thanks Harvey