How do I add "last updated" to a dashboard?

JMcGill

Hello, wondering if you might be able to help me, @Paul Newcome. I too want to display the last modified date on a dashboard automatically. I know how to add a metric widget but it's the formula that I'm missing.

I have a separate calculation sheet that I want to link to the main datasheet's last Modified date column. I also know I need this in a Date column for it to work. Here's the formula reference but it's not working:

=MAX({Master Data Sheet Range 1},[Modified date]:[Modified date])

Mike Wilday

Is there a specific error you're getting? Did you ensure that you only have one column selected in the Sheet Range 1 dataset?

Mike Wilday

Actually, the issue is in your formula... You don't have to select the range after the comma because you are already selecting the range in the dataset. Try this:

=MAX({Master Data Sheet Range 1})

Paul Newcome

@JMcGill You will need to follow @Mike Wilday's suggestion of only having the one range. You will also need to convert it into a text string and put the formula in a text/number type column if you are also wanting to display the time portion of the date/time stamp. You can convert it into a text string by "adding" quote quote to the end of it.

=MAX(..............) + ""

JMcGill

Thank you!

Mike Wilday

You're welcome. Glad I could help out.