A short excerpt from a YouTube tutorial by George B. Thomas explaining how to create a ClickUp formula field that calculates the difference in days between a task's due date and close date. The presenter demonstrates using this metric to report whether tasks were closed early or late, and shows a live example from a video production team's performance-tracking setup.
A formula field works on a per task basis of close date versus due date. I'd be reporting on what's the difference? Did they close it early? Did they close it late? And this is how I'd be evaluating performance. And in fact, this is something I'm using right now in our own video production area to check in on certain team members who have personal goals of trying to finish things before their due dates. I was like, hey, we can do this. It's just a formula. What that looks like is the days between the due date and the close date, and it'll report that number here. So let me just go ahead and put a little string at the end. So the due date, let's just say, is tomorrow. If I close it right now and I show close to make sure it doesn't go away. It was closed one day early.
