how do I get the most recent time/date from modified column onto a dashboard?
I am looking to identify the most recent update of a sheet using the modified column. I was able to use the MAX formula in a date column but date columns won't include the time. I tried using the same formula on a text/number column but came up with the error "Invalid Column Value". This data exists on a sheet, it seems silly that I can't find a way to show the most recent time/date on a dashboard.
Is there a way to get this time into another column that I am missing or another route outside of using a formula to get this on a dashboard?
Best Answer
-
Figured out a solution to my own issue for those trying to do the same thing. I created a report and included the modified date and sorted from newest to oldest. Then on the dashboard I made the widget only show one row.
Answers
-
Figured out a solution to my own issue for those trying to do the same thing. I created a report and included the modified date and sorted from newest to oldest. Then on the dashboard I made the widget only show one row.
Help Article Resources
Categories
Check out the Formula Handbook template!