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

SuzanneH

I have a dashboard widget linking to a group of different smartsheets. I would like to add the last updated date (and name would be great too) so that the viewer will know if updates have been made without clicking into the sheet. What is the best way to do this?

Paul Newcome

@SuzanneH

Please don't be scared. We're all a little crazy here, but between the three of us we should be able to help you with a solution.

Andrée Starå

@SuzanneH

I'm always happy to help!

Have a fantastic weekend!

Mike Wilday

Can you provide a screenshot so we can see what you're doing? I have some ideas on how that can be done.

Paul Newcome

I have a few ideas as well, but as @Mike Wilday said... Screenshots would definitely help.

Andrée Starå

Hi Suzanne,

I'm the third person with ideas and asking for screenshots! 😉

Basically something like, collect the latest date and with name from each sheet on a so called Master Metric Sheet and show it in the Dashboard.

We could also use the Sheet Summary and Sheet Summary Reports.

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

@Andrée Starå That's pretty much the same thought process I was having.

Andrée Starå

@Paul Newcome

https://media.giphy.com/media/LrGHJGtTbT7PO/giphy.gif

Mike Wilday

@Andrée Starå @Paul Newcome

MEEE tooooo! 😂

Paul Newcome

@Andrée Starå

😂😂😂

Paul Newcome

@SuzanneH

Please don't be scared. We're all a little crazy here, but between the three of us we should be able to help you with a solution.

Andrée Starå

@Paul Newcome @Mike Wilday 🤣

SuzanneH

Haha! Thanks so much to all! Ok I have a grid. And I have a series of reports running off the grid that different people will access for the purpose of updating the primary grid. I want management to have a quick glance to know who hasn't updated yet this week. Yes they can open the grid and check the modified col, but really I want them to know which sections were updated. The widget should be the links to the reports and then somewhere I would like to include "last updated (max date of the modified by column for the rows in question). As far as if that is done in a table, or if I separate the reports into different widgets and put into the widget heading.. either would be okay to start.

Paul Newcome

What I would suggest (and it seems to be the consensus) would be to create a new sheet. On this new sheet you would have 3 columns.

Sheet Name................Last Updated.................Updated by

Sheet A.................................f1a....................................f1b

Sheet B.................................f2a....................................f2b

On each of the individual sheets, you would include both of the system generated columns for updated (date and person).

f1a would look something like this...

=MAX({Sheet A Last Updated Date Column})

f1b:

=INDEX({Sheet A Updated by Column}, MATCH([Last Updated]@row, {Sheet A Last Updated Date Column}, 0))

Then you would replicate these formulas for Sheet B, Sheet C, so on and so forth.

Once you have built out your table, you could then reference this using a Metrics Widget on your dashboard.

SuzanneH

Thank you! I'll put this together today. It sounds like it should work.

Paul Newcome

@SuzanneH Let us know how it works!

Andrée Starå

@SuzanneH

I'm always happy to help!

Have a fantastic weekend!

Becky Horton

Hi all, wanted to let you know that I used this thread and Paul's suggestion and it worked beautifully! I am using it to show the last modified date on a dashboard that we call our project plan. Thank you for the suggestion!