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

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?
gerardw

Jotform Support

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?

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

Jotform Support

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