Checkbox Formula
I am struggling to use a formula within a checkbox column. I was able to complete the first function of finding the % complete of Children Checkboxes using this =VALUE(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN())) * 100 + "%"
However, now I need to find the % complete of those total values. (So the totals of grandchildren (but not greatgrandchildren - which makes the descendants option challenging.)
Any suggestions are appreciated.
Best Answer
-
I would suggest using a helper column to pull the percentages over and do the calculations there, then using a cell reference in the checkbox column.
Answers
-
I would suggest using a helper column to pull the percentages over and do the calculations there, then using a cell reference in the checkbox column.
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!