Return cell value generated by SUM formula as a number

edited 12/09/19 in Formulas and Functions

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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!