Collecting Dates Marked Past Due for a Dashboard

Eva7C

I want to collect all references from columns with dates that are past due from a sheet so I can pull the data into a Dashboard. I have a separate data sheet to collect the Dashboard data but what formula do I need to use to pull dates in a particular column that may become past due?

SmartWay360

Hi,

My recommendation would be to create report with the data you want and then publish the report.

Best,

Beata

Eva7C

I'm not sure what condition I need to setup in a Report to have it pull dates that are past their due date.

Paul Newcome

Are you able to provide some screenshots for context?

Eva7C

Sure. The above is a Project sheet that has In Store Dates and Ship Dates. I want to have how many are past due in each category show up on my dashbaord. I was going to create a metrics sheet for the data, but someone said to make a report and have it pull form that. After looking in the Report prompts, I don't know what formula to select so that it pulls the dates that are in the past.

Paul Newcome

Report vs Formula is going to depend on how you want to display the data on the dashboard. Do you want just the numbers or were you thinking you would display it as some type of chart?

Eva7C

I just wanted it to be numbers. A chart is nice but not needed.

Paul Newcome

Just numbers I would suggest using a formula in a separate sheet.

=COUNTIFS({Date Column}, AND(ISDATE(@cell), @cell< TODAY()))

What designates a category for the breakdown? Would it be the parent rows?