condition for calculating days

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have a following situation 
  • I have one field that represents Project start date
  • During projects I have a field that sums up all delays during the project (start of delay-end of delay) - one project can have many delays relationship
  • With this I have project duration that gives me how long does the project last - total delay duration
Now I've inserted field PILOT DATE (date when we've started with the pilot)
The problem is when I want to calculate TIME TO PILOT (time from the start of the project to pilot date minus delays in between)

Is there a way to enter a condition to give me only delay duration up until PILOT DATE, and exclude all delays after the pilot date?
Photo of Nenad Ilic

Nenad Ilic

  • 734 Points 500 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
If you have your pilot date on your project patent record, it can be looked up down to the delays table.  The change your formula for the delay days calculation to limit it to take into account the pilot date.