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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!