How to create a chart widget for status (Green, yellow, red)?

Alex Molina
edited 03/13/23 in Smartsheet Basics


I have a picture of what I want to do, but can't with the selected data set. I tried, but it said data cannnot be charted. I selected the data range primary and status.



  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭

    @Alex Molina

    I use a metric sheet to roll up some of that data, and then pull my chart from the Metrics. You would pull it as data (a number) and then in the chart widget, you would color it there.

    Smartsheet Community Champion and Ambassador

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.