Lead Time calculation

I am trying to create a lead time calculation to see when a request for work was submitted vs what the due date is. Purpose to report on lead time to promote better planning.

I had this working when I had a request date in my form. However I subsequently changed that field to a "created date" system field to auto populate and am unable to get the formula working again.

I tried to change the formatting of the "created date" column to match my other date formats but unable to do so.

Any idea how I can calculate the lead time on a job?

Find more posts tagged with

Formulas

Accepted answers

dojones

Check to make sure Due Date is a Date field. Then use =[Due Date]@row - [Created Date]@row to get number of days. If you want it to be dynamic from today's date, use =[Due Date]@row - TODAY()

All comments

KPH

If you want to extract just the date from the system generated column you can use the DATEONLY function. Either put this around the column name when using it in your original formula (DATEONLY([Created Date]@row)) or make a new column to hold the date only (in date format) and use that in your formula.

Be aware - if you are not in GMT the date returned by the DATEONLY might not be accurate. It will change to a new date at midnight GMT even if the Created Date column shows the local time. For example, in PST the Created Date might show 09/01/2024 5:00 PM but the DATEONLY would be 09/02/2024 as 5pm PST is 1am GMT. If this is a problem for you, there is a work around but it is more complicated. Let us know if you need it.

dojones

Check to make sure Due Date is a Date field. Then use =[Due Date]@row - [Created Date]@row to get number of days. If you want it to be dynamic from today's date, use =[Due Date]@row - TODAY()

vanstadenster

Thank you so much @dojones that worked. So happy and it was so simple.

Thanks so much @KPH for your explanation - I need to learn a lot more as to how to put formulas around a column name.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.