Dashboard Metrix Widget - Modified Date Column For Multiple Updates

Art Miller

Hello,

Creating a dashboard with one source sheet and want to show the latest date when any row is modified in the sheet. Easy to select just one cell to represent this with the metric widget. However I need a formula that will pull the latest modification date from the modification column.

Appreciate any help with a formula or any other suggestions to accomplish this.

Thanks!

Art

Art Miller

Found my solution. The =max formula I had tried earlier wouldn't work until I changed the column I had the formula in to a date column. All good now! - Art

Art Miller

Found my solution. The =max formula I had tried earlier wouldn't work until I changed the column I had the formula in to a date column. All good now! - Art

Andrée Starå

Excellent! 

Glad you got it working! 

Best, 

Andrée