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.

Sights widget for Quarter over Quarter Status trend?

edited 12/09/19 in Archived 2016 Posts

In the CIO Sight in the Sights gallery, what widget did they use to get the quarter over quarter status trend? Looking to do something similar and not sure how to go about it.



  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    The widgets they used were probably either the Sheet or Report Data Widgets.  Then they have a sheet/report that is displaying this data or has formulas calculating this data as a summary on a sheet and then displaying this data from the sheet. 



  • Travis
    Travis Employee

    Tim is correct! The particular widget you are referring to is the reporting widget. The data is calculated in a sheet added to a report. The report is then added to the Sight through the report widget. 

  • Thanks guys! I have created a report that shows the numbers I need. The formatting doesn't look as good as the gallery one yet though.



    q over q sight gallery.PNG

    sights by stage.PNG

    month over month.PNG

  • Travis
    Travis Employee

    Sights should pull formatting from the report. Try reducing the column width from within the report, save the report, then refresh the Sight. 

This discussion has been closed.