Using the Smartsheet Task List, how can I present a % complete or progress wheel

Michele Deo

I'm using a Smartsheet task list template and I'd like to show how many tasks out of all tasks is completed, like a progress wheel or % complete?

Paul Newcome

The basic idea would look something like this...

=COUNTIFS([Status Column]:[Status Column], "Complete") / COUNTIFS([Status Column]:[Status Column], OR(@cell = "Complete", @cell <> "Complete"))