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

02/16/16 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

Comments

  • Atus BartalAtus Bartal ✭✭✭✭

    Irene,

     

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

     

    Atus

  • Atus BartalAtus Bartal ✭✭✭✭

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

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

  • Thank you so much Atus this works perfectly!! Laughing

This discussion has been closed.