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
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives