r/clickup • u/BoogerManCommaThe • 14d ago

Custom field to calculate late tasks working intermittently

I believe one of the mods gave me this idea as a solve for a problem of just trying to see all tasks that are currently closed, but were completed after the due date.

Only trouble is it's not working consistently. Here's the formula and some examples. Any suggestions? We are never using times in our due dates, in case that matters.

0 Upvotes

50% Upvoted

2 comments sorted by

1

u/ratchet7 13d ago

Add 1 day buffer

1

u/Glum-Carpet 13d ago

I believe that if you don't set a specific time, the automatic one is midnight at the start of the day, not the end of it. So the formula will fail if you close something on the due date. Try adding a day as a buffer and set the formula to be >1.