Spreadsheet widget: How can I round up the decimal digits to 2 digits only?

  • Profile Image
    mklinks
    Asked on September 26, 2019 at 09:49 PM
    On my '% Kg' cells, How can I round up the decimal digits to 2 digits only?
  • Profile Image
    gerardw
    Answered on September 26, 2019 at 10:13 PM

    I tested your form and it seems you are referring to this value in the "% Kg" column, right?

    15695498402709_4.png

    Unfortunately, upon further testing, there is currently no option to round up the decimals to 2 digits. 

    Let me escalate this as a feature request to our back end team. At the moment we would not be able to provide an ETA, but we will keep you posted on updates via this thread.

  • Profile Image
    mklinks
    Answered on September 26, 2019 at 10:21 PM

    Thank you.

    Could you please also ask your back end team if we could restrict some cells to numeric dat only?

  • Profile Image
    gerardw
    Answered on September 26, 2019 at 10:36 PM

    Hello,

    I have moved your new query to a new thread and will answer that shortly. You can check the new thread link here: https://www.jotform.com/answers/1980177