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

Dick Conradie
edited 12/09/19 in Archived 2016 Posts

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

  • Hi Kennedy

     

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

     

  • J. Craig Williams
    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
    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 Williams
    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

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

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