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
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives