Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to Use a widget in Sights to show when an entire sheet has been modified by date?
I would like to know how to use a widget in sights to have a ongoing updated date whenever the entire associated sheet has been modified or changed. I have seen it on the sights help page and I have viewed it by watching the tutorial video but there is nothing referencing how to actually create it. I have attached a picture to see what I mean. *(Last Updated On)
Your assistance with this is greatly appreciated.
Thanks!
Comments
-
On your referenced sheet, add a System Column for the Date Modified. When you save the sheet, Smartsheet will automatically populate the cell with the date that row was last modified.
Add a Metric Widget to the Sight referencing the specific Date Modified cell you would like. Your top level or summary task is often a good candidate for this. As your sheet gets update, the metric cell will update on the Sight.
Robert
-
Thank you for response, it is greatly appreciated.
So, that I am clear, after I create the System Column, I should be able to get an ultimate automatic last modified update regarding the referenced sheet, no matter what is changed within the sheet?
Ultimately, I just want one date to display on the dashboard of the last changes to the sheet regardless of what is changed. The widget on Sights will only need to have one date.
Can this be done?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives