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.
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.
When building this report an incorrect filter was added to the report (see picture). After it was added, we were unable to delete the filter, edit anything within the report, or edit columns in the sheets tagged to the report. Does anyone have a solution to this?
Is there a way to see where data is coming from if it is input or copied into a sheet by an automation? I have a sheet that is receiving to lines of data every night. I am not sure where these two lines of data are coming from. Initially I thought I was just failing to delete everything I didn't need after a sort, but I…
