Need help getting a percentage of checkboxes

 I have a column with check boxes. I want to get a percentage for total number of boxes that are checked vs the total number of boxes (checked or unchecked). I want this in the parent row to count the children rows only. I got the below formula to work however when I go to use the percentage in a pie chart it wont accept the data. I suspect this is because Smartsheet somehow doesn't see it as a number but a text format? I know that unchecked equals 0 and checked equals 1. Just not sure how to program it. 


=COUNTIF(CHILDREN(), true) / COUNT(CHILDREN()) * 100 + "%"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!