Last Reported Date

Jodi C

I have a sheet that lists all safety incidents in the company and I want to be able to pull the latest date onto my overall dashboard. Is this possible?

Deric

@Jodi C

=MAX([saftey incident date column]:[safety incident date column])

Deric

If you already have the latest date in a specific cell, you can use the metric widget to add the data from the grid data. You can also create a formula in the sheet summary field, then use a metric widget to add data from the sheet summary field.

Jodi C

Thanks @Deric.

Because there will always be new rows added when incidents happen, I don't think we can use your first option. However, I think the formula would work - what is the formula?

Deric

@Jodi C

=MAX([saftey incident date column]:[safety incident date column])