Hypen appears after the Submissions ID on Google Spreadsheet

  • Profile Image
    Asked on October 08, 2014 at 04:12 AM
    Also, I'm getting an hyphen with the submission ID on Google Spreadsheets.... It seems that it just started to happen for no reason...
  • Profile Image
    Answered on October 08, 2014 at 04:22 AM


    Sorry for this inconvenience.

    We are aware of the issue as seen on the image below. That was a hack in order to update submission IDs on the spreadsheet correctly. Otherwise, updating submissions would end up with exponential numbers like 2.688 E+8. So it is necessary until our developers can restrict submission IDs to string type only. 

    Google spreadsheets were working normally without a hyphen before they switched to Spreadsheets v2. However, don't get me wrong as I have this submitted to our developers for further investigation and so you will get updates once this is resolved.

    Thank you!

  • Profile Image
    Answered on October 27, 2014 at 09:02 AM


    any update on when this will fixed as it is important to how we use google spreadsheets

    or is there a formula where we can keep the numbers only?


  • Profile Image
    Answered on October 27, 2014 at 10:11 AM


    Unfortunately we still don't have an update regarding this issue. But rest assure that the dev/technical team has been informed regarding this.

    For a temporary workaround, if you are looking for a formula to be used in the Google Spreadsheet just to remove the hypen, you can use this formula to a new column (ex. column "I"):

    =LEFT($H2, LEN($H2) -1)

    Assume that the column for Submission ID is in "H" and starts with row "2". Then the output will reflect on column "I", just drag the current cell with formula all the way to the rows below, so that the changes can be applied to existing values in the rows in column "H".


    Let us know if this helps. Regarding the issue, we will notify you when our developers have resolved this.


  • Profile Image
    Answered on January 08, 2015 at 01:03 PM


    We have finally fixed the issue regarding dashes behind submission ids. Please accept my apologies for the delay.

    Thank you very much for letting us know

    Kind regards