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?

cme14041
cme14041
edited 12/09/19 in Archived 2017 Posts

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!

program-status.png

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?

This discussion has been closed.