Using the Smartsheet Task List, how can I present a % complete or progress wheel
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?
Answers
-
The basic idea would look something like this...
=COUNTIFS([Status Column]:[Status Column], "Complete") / COUNTIFS([Status Column]:[Status Column], OR(@cell = "Complete", @cell <> "Complete"))
