Chart to Display Count of Complete vs Incomplete

Jennifer Dewhurst
Jennifer Dewhurst ✭✭✭
edited 12/09/19 in Smartsheet Basics

I am trying to display a chart on a dashboard that displays Complete vs incomplete items using a single column on one sheet as a source.  Should I create a report, then generate a metric widget? What is the best way to do this? 

· Share on FacebookShare on Twitter

Comments

  • Michael Kingsbury
    Michael Kingsbury ✭
    edited 11/06/18

    What i do is make another "Utility" sheet and use a COUNTIF()/ COUNTIFS() formula. 

    IE 

    Completed Items                                                

    =COUNTIF({Sheet Range 1}, "Completed")       

    Incomplete Items

    =COUNTIF({Sheet Range 1}, "Incomplete") 

     

    After that use the Metric widget and display those items. It will auto update after you make changes in your sheet which is nice.

     

    If you want more criteria use COUNTIFS() Like Completed items that are in "X" Department or whatever.

    Michael 

    · Share on FacebookShare on Twitter
  • Jennifer Dewhurst
    Jennifer Dewhurst ✭✭✭

    Thanks Michael!

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video