# Percentage of Child Rows with Check Mark

âś­âś­âś­
edited 12/09/19

Hi,

I'm trying to get a Percentage of Child Rows with Check Mark. Can anyone help out?

=COUNTIF(CHILDREN(), 1) + ""

returns the count of checked boxes.

=(COUNT(CHILDREN(), 0) + ""

returns the count of total rows, check or unchecked.

So I divided the two, but I get #INVALID OPERATION error.

Â

Any thoughts?

Â«1

• âś­âś­âś­âś­âś­âś­

you are converting the value inside of the cells into a text value by adding the space. I assume you are doing that to format the text to the center. Instead you should use the formatting tools. If you really feel the need to keep the space there you could probably get away with using the value() formula, but it's not really recommended in this case.

Â

=Value(Aconex@row)/value(Procore@row)

• âś­âś­âś­âś­âś­âś­

This formula

=(COUNT(CHILDREN(), 0) + ""

is incorrect (it is off by 1)

=COUNT(CHILDREN()) + ""

is.

Craig

Â

• âś­âś­âś­

Thanks Luke,

I'm not trying to divide Aconex into Procore.

I'm trying to Divide the number of checked Aconex boxes into the total number of Aconex boxes.

=(COUNTIF(CHILDREN(), 1) + "") / (COUNT(CHILDREN(), 0) + "")

Â

• âś­âś­âś­

J.Craig,

=(COUNTIF(CHILDREN(), 1) + "") / (COUNT(CHILDREN()), 0) + "")

I used this, but it's not working.

• âś­âś­âś­âś­âś­âś­
edited 09/19/18

Use Luke's suggestion of VALUE() to get your text into numbers.

Remove the trailing 0 from your COUNT formula.

If you are putting this formula in a Checkbox column, you need to convert it back to Text again (or skip it if you are replacing your current counts 4 and 16)

=(COUNTIFS(CHILDREN(),1) / COUNT(CHILDREN())) + ""

Craig

• âś­âś­âś­âś­âś­âś­

=COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) + ""

Â

Thats a neat trick using the quotes to change the format to be acceptable to a boolean column. Hadn't seen that before.Â

Â

Try that formula. It seemed to work for me when I tested it.

• âś­âś­âś­âś­âś­âś­
• âś­âś­âś­

This gives me a #Divide By Zero error.

Â

Â

• âś­âś­âś­

If anyone wants to take a try at it, here you go:

<IFRAME WIDTH=1000 HEIGHT=700 FRAMEBORDER=0 SRC="https://app.smartsheet.com/b/publish?EQBCT=bd662b969cf048708c879cd9ae8ba4d8"></IFRAME>

Â

• âś­âś­âś­âś­âś­âś­

In a Checkbox column?

It should not if you have children (checked or unchecked).

Craig

Â

• âś­âś­âś­âś­âś­âś­
edited 09/19/18

Fixed. You had no children (rows need to be indented)

Craig

• âś­âś­âś­

I just saw that and changed it, and it works.

Thank you so much J.Craig!

• âś­âś­âś­

The result reports as .25 instead of 25%.

Do you have any thoughts on fixing this?

• âś­âś­âś­âś­âś­âś­

Highlight the cell and click the little % up by the dollar sign in the top bar

• âś­âś­âś­

That doesn't work.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!