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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!