How can i multi column to column?

hoangnh

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

Shaine Greenwood

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.