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

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.

Best Answers

  • Bill Lafferty
    Bill Lafferty ✭✭✭✭
    Answer ✓

    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!