Ratio being interpreted as date in Google Sheets

  • Profile Image
    BuryTrainingServices
    Asked on October 26, 2020 at 09:45 AM
    the other issue is i have a entry on form for the trainee ratio which could be on most occasions be 1.1.1 however this then gets interpreted as a date when in google sheets.
  • Profile Image
    Sonnyfer
    Answered on October 26, 2020 at 09:52 AM

    Apologies for the inconvenience.

    I checked one of your forms with the word Trainee (https://www.jotform.com/form/202963998109368) but can't seem to find the ratio field. Are you perhaps referring to a different form? If so, kindly share its URL so we can check.

    Guide: Where-to-Find-My-Form-URL

    Moreover, we'd appreciate it if you could send us screenshots to better illustrate the issue. Here's How-to-Post-Screenshots-to-Our-Support-Forum.

    Looking forward to your reply.

  • Profile Image
    colin Jones 
    Answered on October 26, 2020 at 11:03 AM

    hi there


    sorry should have said what forms.

    its on all form except the trainee info

    please look at file ind lift trucks

  • Profile Image
    Kenneth_C
    Answered on October 26, 2020 at 01:54 PM

    Hi there,

    I can't seem to replicate the issue, can you share with us the Direct form link for the form that exhibits this issue?

    Here is how: https://www.jotform.com/help/401-where-to-find-my-form-url?

    Awaiting your response.

    Best.