Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

#Unparseable error

08/22/16 Edited 12/09/19

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?

 

 

Normal_Status.jpg

Normal_Status_Formula.jpg

Normal_Status_Formula_Error.jpg

Comments

  • 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 [email protected] 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.

  • Hi Kennedy

     

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

     

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    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

  • edited 09/20/16
    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 WilliamsJ. Craig Williams Top Contributor

    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

  • 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 WilliamsJ. Craig Williams Top Contributor

    =100 - SUM() 

     

    is not a valid formula.

    SUM requires arguments, typically a range.

     

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

     

    Craig

     

     

  • edited 04/05/17

    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.

     

    Error.png

    Formula.png

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    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

  • edited 10/08/18

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

    Capture.JPG

    Capture A.JPG

  • 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 WilliamsJ. Craig Williams Top Contributor

    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

  • Thanks so much!

  • 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.

This discussion has been closed.