How to track items that are completed after their due date

Tiffany White

Hello!

I'm trying to track tasks that are completed after the due date. I used this formula to indicate when an task was past due and not complete but once the task is checked off as complete it no longer works, well it works it just doesn't give me the data I'm looking for. 

=IF(AND(TODAY() = DUE5 + 1, Done5 = 0), 1, 0)

I'm trying to keep away from having staff enter the date they completed the task but am not sure how to do this.

Does anyone know a formula that I could use to indicate if a task went past due before being complete? Any help would be appreciated!

Thank you!

Mike Wilday

At this point, its not possible to avoid having people enter dates to track completion timing. We ended up adjusting our status column to track whether there was an actual completion date. And indicate the status based on whether there was an actual start and an actual finish. As of right now, you can't set a date/time when something was checked off, or changed to a certain status.

 

Tiffany White

That's disappointing but thank you!

Mike Wilday

You're welcome.

Please consider submitting an enhancement request to be able to use the date that a specific dropdown selection was chosen as a flag for your formulas. There are many of us who would like to be able to see/use the date a field is changed to indicate the status of something being completed. Add your vote by submitting a request. 

Andrée Starå

Hi Tiffany,

A possible workaround would be to use a third-party tool like Zapier or similar.

Would that be an option?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Tiffany White

I definitely will! Thanks again

Tiffany White

Hi Andrée,

It's definitely worth looking into, thank you!

Cheers

Andrée Starå

Excellent!

Let me know if I can help in any way!

Have a fantastic weekend!

Best,

Andrée