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

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?