There are many ways to achieve this. One approach is to create a "Count" field (labeled "Overdue Tasks") in your "Project" table to see how many tasks were completed late. In this field, you can filter tasks that meet the criteria of being overdue.
For example, you could set it up like this:
References:
I hope this helps! If you need assistance implementing this solution, feel free to schedule a free call with me.
- Juan, Code and No-Code Solutions Expert
How to do this varies based on how your data's setup so if you could provide screenshots of that it'd be really helpful!
There are many ways to achieve this. One approach is to create a "Count" field (labeled "Overdue Tasks") in your "Project" table to see how many tasks were completed late. In this field, you can filter tasks that meet the criteria of being overdue.
For example, you could set it up like this:
References:
I hope this helps! If you need assistance implementing this solution, feel free to schedule a free call with me.
- Juan, Code and No-Code Solutions Expert
Hi Juan,
Thank you for the suggestion. Unfortunately, that did not work. I experimented by creating an overdue task, and while in the "todo" and "in progress" statuses, the task was counted as overdue, but as soon as I marked the task as "done" it was removed from the "no. overdue" count and was added to the "no. done" formula column.
Should I keep the "is overdue" formula column I have so I can see how many are currently overdue in a "no. currently overdue" column, but is it possible to add an additional formula column called "ever overdue" (or something like that) which will still count items that were overdue and done? Then I can add a count column for "no. completed overdue" ?
Hi Juan,
Thank you for the suggestion. Unfortunately, that did not work. I experimented by creating an overdue task, and while in the "todo" and "in progress" statuses, the task was counted as overdue, but as soon as I marked the task as "done" it was removed from the "no. overdue" count and was added to the "no. done" formula column.
Should I keep the "is overdue" formula column I have so I can see how many are currently overdue in a "no. currently overdue" column, but is it possible to add an additional formula column called "ever overdue" (or something like that) which will still count items that were overdue and done? Then I can add a count column for "no. completed overdue" ?
Well, I answered my own question. I tried to set up this "ever overdue" formula column and asked AI for help. It said it's not possible 😞
I suppose I could add an additional status called "done overdue" and then have a count column associated. If a project was done overdue, we'd select that option rather than simply "done" or maybe I could rename it "done on time".
I will think some more and decide if this type of data is truly necessary. Thank you for helping me sort out this situation!
Well, I answered my own question. I tried to set up this "ever overdue" formula column and asked AI for help. It said it's not possible 😞
I suppose I could add an additional status called "done overdue" and then have a count column associated. If a project was done overdue, we'd select that option rather than simply "done" or maybe I could rename it "done on time".
I will think some more and decide if this type of data is truly necessary. Thank you for helping me sort out this situation!
I've managed to do this kind of thing before, so if you're open to potentially making some changes to your base setup this is possible!
Well, I answered my own question. I tried to set up this "ever overdue" formula column and asked AI for help. It said it's not possible 😞
I suppose I could add an additional status called "done overdue" and then have a count column associated. If a project was done overdue, we'd select that option rather than simply "done" or maybe I could rename it "done on time".
I will think some more and decide if this type of data is truly necessary. Thank you for helping me sort out this situation!
Schedule a call with me and we'll get this thing sort out for free.
- Juan, Code and No-Code Solutions Expert
