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

Irene Plant
edited 12/09/19 in Archived 2016 Posts

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

Comments

This discussion has been closed.