Return cell value generated by SUM formula as a number
Is there a way to return the numerical value of a cell that contains a formula that is counting the number of checked boxes in its children cells? My current formula in the cell is: ="Complete: " + SUM(COUNTIF(CHILDREN(), 1) + COUNTIF(CHILDREN(Complete96), 1))
in order to count the number of checked boxes in all children across multiple hierarchies, i.e., "Complete: #"
I tried the N() and Abs() functions with no success.
Thank you!
Comments

Hi,
Depending on your sheet structure I would recommend to sum the children of each section and then sum the children from the first parent. You would have to put the formula in each parent (except the top one that will be just for summing the children) to count the checked boxes.
If you could share a screenshot, I can help more efficiently.
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

="Complete: " + SUM(VALUE(COUNTIF(CHILDREN(), 1)) + VALUE(COUNTIF(CHILDREN(Complete96), 1)))
Try using the VALUE function to ensure the individual portions are actually generating numbers to add together within your SUM() instead of a text string.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!