# Calculating % of Yeses in child rows from Yes/No Column

✭✭✭✭✭

I am looking to get a percent of "yes" in a column named "Yes/No" in the parent row. Example, I have a parent row with 5 child rows - 4 of the child rows have "yes" one has "No" I am looking to show the % of "Yes" in this case the result should be 80% with Yes.

Thanks

Tags:

• Overachievers

@MarkCep Try this

=COUNTIF(CHILDREN([yes/no]@row), "Yes") / COUNT(CHILDREN([yes/no]@row))

Might need to wrap iferror around it

=IFERROR(COUNTIF(CHILDREN([yes/no]@row), "Yes") / COUNT(CHILDREN([yes/no]@row)), "")

• Overachievers

@MarkCep Try this

=COUNTIF(CHILDREN([yes/no]@row), "Yes") / COUNT(CHILDREN([yes/no]@row))

Might need to wrap iferror around it

=IFERROR(COUNTIF(CHILDREN([yes/no]@row), "Yes") / COUNT(CHILDREN([yes/no]@row)), "")

• ✭✭✭✭✭

Fantastic, this worked perfectly.

Thank you so much

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!