#Unparseable error

I'm using the system to monitor and report progress to our client. We do surveys on their sites and perform installations. On top of the sheet, I have locked 6 lines that I use for summaries of the totals with simple countif statements.

Any ideas on why?

Find more posts tagged with

Workspaces

Sheets

Sharing and Collaboration

Formulas

Dashboards

Comments

Kennedy Stomps

Hi Dick-- I'd be happy to take a closer look at this sheet, can you please share it (or a copy) with me at Kennedy.Stomps@Smartsheet.com offering Admin permissions? I suspect there is an issue with the reference getting wiped when new rows are added, but I'd like to do some more troubleshooting on this.

Dick Conradie

Hi Kennedy

I've shared it with you. Thanks for the assistance.

J. Craig Williams

Was this issue resolved?

This doesn't look like a new row issue but rather a deleted one.

I'm curious to know the cause and solution.

Craig

Dick Conradie

The developers are still investigating why it actually happened, but they advised me to change the formulas to calculate the full column instead of a range, such as =COUNTIF([Business Unit]:[Business Unit], "Glo1"), instead of =COUNTIF([Business Unit]8:[Business Unit]:400, "Glo1")

That solve my problem. After I've done that, it did not happen again.

This error was very random. Sometimes it happened when you just add information in an existing row, sometimes when you add new ones or when you filter.

J. Craig Williams

Thanks for the update.

I try to avoid hard-coded references when I can. Maybe that is the reason I haven't seen this error yet.

Craig

Donald Antoncich Jr

I am getting the same error. I am using a simple command =100-SUM() and getting the #unparseable. Once the cell says that I can not input any working formula into that cell again. Even after clearing the cell. I believe this began when someone tried updating the Smart Sheet with the SS App on their phone.

J. Craig Williams

=100 - SUM()

is not a valid formula.

SUM requires arguments, typically a range.

https://help.smartsheet.com/articles/775363-using-formulas#sum

Craig

Miguel Gamboa

I have a similar issue or it looks like someone had the error im getting im trying to get a sheet i have to assign what quarter a request was made. This is being fed by a form my customers fill out. The form works great and i'm trying to add this formula to it to assign the quoter in a new column.

=if([Requested Date]1=" "," ",roundup(Month([Requested Date]1)/3,0))

am i missing somthing or doing something wrong i dont recognize this errorand cant figure out what i should change.

J. Craig Williams

roundup is not a function in Smartsheet.

Try ROUND() instead. That will however give you incorrect results

Here's my formula for the Quarter determination:

=IFERROR(INT((MONTH(Date23) - 1) / 3) + 1, "")

for [Date] column row 23.

Craig

c.carstens63826

I am getting the same error. I am using a simple command =SUM(Total Billable820:Total Billable828) and getting the #unparseable error.

Capture A.JPG

Samantha Nolan

Can anyone tell me if you can =SUM() from multiple sheets? I am trying to do a very simple SUM command for ranges across two sheets to link to the "master" sheet and continue to get the #UNPARSEABLE response.

J. Craig Williams

Yes, it is possible.

SUM just takes a set of arguments. The arguments can be ranges. The ranges can be x-sheet references.

If you use SUMIF or SUMIFS, then you need to make sure you do them individually and add them together because the ranges may not be the same size.

Craig

Samantha Nolan

Thanks so much!

Katya

Same error. I have three sheets imported with budgets for three categories. The sum function continues to reference the imported data's original sheet name. Removed this in the formula and it works.