Using check box to complete a task. Field is called completed. Need help to make formula for days overdue. Thanks all!
 0 Points
Posted 4 years ago
QuickBaseCoach App Dev./Training (Mark Shnier), Champion
 72,226 Points
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.
 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.
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.
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.
 0 Points
Related Categories

Formulas & functions
 3036 Conversations
 81 Followers

Tables & fields
 7324 Conversations
 200 Followers