Formula for over due tasks using checkbox.

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

Using check box to complete a task. Field is called completed. Need help to make formula for days overdue. Thanks all!

Photo of Ken

Ken

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,320 Points 50k badge 2x thumb
Can you explain in English what the calculation needs to be?  So far i only know that you have a table with a checkbox field in it.
Photo of Ken

Ken

  • 0 Points
how many days a project is overdue from the due date of the task. I am using a checkbox for when a task is complete. So once the task is past the due date and is not checked as complete, i need to know how many days it is past due. Happy to provide any more info and thank you.
Photo of Jack

Jack, Champion

  • 50 Points
Hi Ken,

Create a formula duration field and set the units to days and use a formula like:

If(
[completed]=true,days(0),
Today()-[Date due field]<Days(1),Days(0),Today()-[Date due field])

Depending on whether you count the day due you may need to subtract one day from the answer.

If(
[completed]=true,days(0),
Today()-[Date due field]<Days(1),Days(0),(Today()-[Date due field])- days(1))


If this isn't what you wanted please can you elaborate a little on your requirements.
Photo of Ken

Ken

  • 0 Points
Success! You did create the formula. Thank you very kindly.
Photo of Jack

Jack, Champion

  • 50 Points
Your welcome Ken.