Task complete checkbox vs unchecked Donut chart

TristanS
TristanS ✭✭
edited 06/14/23 in Smartsheet Basics

I'm trying to create a donut chart that compares a standard task tracker Complete checkbox vs tasks not complete in a chart. Essentially a percent complete graph based off a checkbox. I can't figure out how do show this with a chart widget in a summary dashboard.

Answers

  • Melissa Yamada
    Melissa Yamada ✭✭✭✭✭

    Hi @TristanS

    Did you try creating a summary sheet with the counts, and then use that data to create the chart widget? A simple COUNTIF formula should work here.

    Melissa Yamada
    melissa@insightfulsheets.com
    Data made simple, spreadsheets reimagined