We have a tasklist of 100 items, they are pretty simple, so really nothing more than a checklist. But when we roll this up to a master smartsheet I would like to roll up a "% complete" value.
Is there a way to sum up the number of rows with a checkbox (checked or not), and divide it into the number of checkboxes that are checked/done to calculate a % complete that is then rolled up to a master project smartsheet?
I was using the checkbox because that is the easiest way to get people to mark when their task is done. People were not using a "status" pulldown with 0%/25%/50%/100%. they only updated at 100% so I changed to a "done" checkbox.
Should I be using "COUNT" or "SUM" to do this? Somewhat of a newbie to smartsheets and I didn't find anything in the search to indicate how to do this, or if I am going about it the wrong way
