Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Past Due Reporting

Mark Chapman

Is there a method to have a report that generates past due tasks?

On our task management sheet, I have a ‘due date’ and ‘date completed’. Once a task is finished, my team members will input the date completed. If the date completed extends past the due date, I would like a report to be generated and available to the Management team.

Comments

selina

I find it's easy to do so.

You can create a reminder when the Due Date is in the past XX days.

See my example.

ss example.JPG

FEspo

Hi All, I agree with Selina. I have several reminders/alerts set up and not 1 uses a formula in a cell. You can set multiple criteria using the automated workflows and you can set it up for a recurrence. See my screen caps.

reminder Flow_1.PNG

reminder Flow_2.PNG

FEspo

BTW... you can also set your reminders to be X days BEFORE the due date to try and avoid the miss altogether.

Sign in to join the Community!

Quick Links

Find more posts tagged with

Reports