How to track items that are completed after their due date

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!

Find more posts tagged with

Healthcare

Formulas

Support

Community Platform

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

INDEX/MATCH Most Recent Entry
I am trying to pull from a sheet that is essentially a list of new records that are entered weekly. To keep things clean I have a helper sheet that just lists the project name once and the rest of the columns pull in through an INDEX/MATCH. I am trying to have that helper sheet pull in only the most recent entry. There is…
Break Up Multi-Entry Row
I'm using a form entry (into an Intake Sheet) in which someone can select multiple locations for the same Initiative. I'm looking to copy the row to a different Master sheet, but would like to have the same row copied multiple times, once per location selected. Intake Sheet: Desired Result in Master Sheet: Basically, I…
Set contents of two columns into 1
Hi - trying to figure out a formula that combines two columns into one long column, maintaining contents in multiple rows. Noting that the number of items in each column will change as these are each using the index/distinct to summarize a separate sheet. For example: Thanks for any help!