#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Combining formulas for child rows

Options
edited 12/09/19

I have an easy formula to work out the average data entered into my child rows, the formula is as follows: =AVG(CHILDREN()), this gives me the average of all data put into the child rows perfectly. However, if nothing is entered into these child rows the parent row with the formula in it just shows #DIVIDE BY ZERO. I would like this to be blank while the child rows are blank. I can do a formula to say if it is blank then put nothing but I'm not sure how to combine the two? Any help would be very appreicated.

Many thanks, Irene

• ✭✭✭✭✭✭
Options

Irene,

you can try this: =IF(SUM(CHILDREN()) <> 0, AVG(CHILDREN(), ""))

Atus

• ✭✭✭✭✭✭
Options

Oh, sorry, a bracket is in a wrong place (but still works somehow)

Correctly: =IF(SUM(CHILDREN()) <> 0, AVG(CHILDREN()), "")

• Options

Thank you so much Atus this works perfectly!!

This discussion has been closed.