Sign in to join the conversation:
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
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.
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
