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? 


  • Michael Kingsbury
    edited 11/06/18

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


    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.


  • Jennifer Dewhurst

    Thanks Michael!