Forum Discussion
QuickBaseCoachD
Qrew Captain
Can you post your formula and the complete error message?
PriscillaFramar
6 years agoQrew Trainee
this is the results from my original formula
If([Status] = "Delivered", null, ToDays(Today() - ToDate([Calculated Finish Date])) <= 0, null, Today() - ToDate([Calculated Finish Date]))
- Initial task shows status �In Process� with days overdue being equal to 7
- If I set the status to delivered, the days overdue field becomes Null
When I add in your formula to Days Overdue (I get the warning I specified, but the formula does save)
If(
[Status] = "Delivered"
and [Actual Finish Date] >= ToDate([Calculated Finish Date]),
ToDays([Actual Finish Date] - ToDate([Calculated Finish Date])),
Max(0, ToDays(Today() - ToDate([Calculated Finish Date]))))
- All Days Overdue turn to null
- If I set the status to Delivered, the Days Overdue is still null
I want to see days overdue for any status and once marked delivered, stop increasing the date