Add a Metric widget on a dashboard that shows last modified date & time

Bill Lafferty

I am trying to add a metric widget to a dashboard that shows both the date and time from the last modified column in a sheet. It seems I can only bring in date, not time. Is there a way to show both elements?

Thanks.

Bill Lafferty

Hi Andrée:

Thanks for the quick response. The data I am pulling from is comes from a sheet with a System column type "Modified (date). Data in the sheet cell is in the format of date/time (MM/DD/YY 00:00PM). The process I am following on my Dashboard is to edit or add a Metric Widget. I do not see or understand where I could add +”” to the end of my formula as there is none. Perhaps I misunderstood your intent. Please advise.

Bill

Andrée Starå

Happy to help!

Ok. That wont work. You'll need to add a so-called helper column or use the Sheet Summary section if you have access to it.

Make sense?

Andrée Starå

Hi William,

Yes, Try adding +”” to the end of your formula. It will convert the result to text.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bill Lafferty

Hi Andrée:

Thanks for the quick response. The data I am pulling from is comes from a sheet with a System column type "Modified (date). Data in the sheet cell is in the format of date/time (MM/DD/YY 00:00PM). The process I am following on my Dashboard is to edit or add a Metric Widget. I do not see or understand where I could add +”” to the end of my formula as there is none. Perhaps I misunderstood your intent. Please advise.

Bill

Andrée Starå

Happy to help!

Ok. That wont work. You'll need to add a so-called helper column or use the Sheet Summary section if you have access to it.

Make sense?