Calculating Lead Time Formula

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I need assistance creating a formula to calculate an on going lead time. Details are it needs to count number of current working days and then once another field is updated show a total working days. I can do this use two separate fields but want to combine it into one field so it easier to report on.

a) Number of working days between 'Request Date' and the current date.

b) Then once a field 'Report Sent' is updated with a date, the field to display the final number of working days between 'Request Date' and 'Report Sent'.


Apologies, I have tried to explain the requirement as best as possible. Thank you for any assistance.

Photo of Andrew

Andrew

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
No problem, your explanation was lucid.

Try this as a formula numeric field called Lead Time Days

IF(not Isnull([Report Sent]),ToDays([Report Sent] - [Request Date]), ToDays(Today() - [Request Date]))
Photo of Andrew

Andrew

  • 0 Points
Thank you that formula works but it currently is counting all the days in a calendar week - ToDays. What is the right function to use so it just counts Weekdays (Mon - Fri)?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
IF(not Isnull([Report Sent]),

WeekDaySub([Report Sent], [Request Date]), WeekDaySub(Today(), [Request Date]))