Finding the Percentage from two values
Hi All,
Sorry for this very basic question, but I am driving myself nuts trying to find the correct formula.
Trying to calculate the total % complete from checked boxes.
I have a count for when boxes are checked and a count for the total number of items listed on the sheet.
How do I get the % of the checked boxes total?
Tags:
Best Answer

To count the whole sheet it would be something like this, ensure the column is formatted as %
=COUNTIF([Task Done]:[Task Done], 1) / COUNT(CHILDREN([Task Done]:[Task Done]))
Answers

To count the whole sheet it would be something like this, ensure the column is formatted as %
=COUNTIF([Task Done]:[Task Done], 1) / COUNT(CHILDREN([Task Done]:[Task Done]))

Thank you!!!!!! I was missing the COUNT in the second part of the formula.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!