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?

tobrien3
tobrien3 ✭
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.

Tags:
· Share on FacebookShare on Twitter

Comments

  • 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. 

     

    Tim

    · Share on FacebookShare on Twitter
  • 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. 

    · Share on FacebookShare on Twitter
  • tobrien3
    tobrien3 ✭

    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

    · Share on FacebookShare on Twitter
  • 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. 

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories