How can i multi column to column?

Options
hoangnh
hoangnh
edited 12/09/19 in Smartsheet Basics

i am use "=AVGW([% R]3:[% R]5);[X]3:[X]5)/count(CHILDREN() " to multi column to column then divide to have a average number.

But smartsheet say "#UNPARSEABLE"

Pls help me 

Thanks u guys

Comments

  • Shaine Greenwood
    Options

    Hello,

    #UNPARSEABLE typically means that you're using parenthesis in the wrong spot. Try this:

    =AVGW([% R]3:[% R]5, [X]3:[X]5)/COUNT(CHILDREN())

    If that doesn't work try:

    =AVGW([% R]3:[% R]5; [X]3:[X]5)/COUNT(CHILDREN())

    If neither work, then your column names may be the issue, or you may be referencing a row that doesn't have any children. Make sure rows are indented under the one that has the formula in it when you use the CHILDREN function.