Spreadsheet widget read-only column

  • byronmcwhinnie
    Asked on November 20, 2019 at 3:41 PM

    Can I lock only some columns in a form using the spreadsheet function? I want the ones with formulas locked but the other ones open for data to be inputted.

    Can I also have it only calculate to a certain number of decimal places? When I get emailed the form it shows that put when people are inputting the data I would like it to only go to two decimal places

    Jotform Thread 2048454 Screenshot
  • Richie JotForm Support
    Replied on November 20, 2019 at 8:58 PM

    It is possible to make a cell in your Spreadsheet widget read-only.

    Example screenshot:This will disable the column 1 of Sieve Mesh and Weight.

    Spreadsheet widget read only column Image 1 Screenshot 30

    Here is a screenshot to determine the cell column and row.


    Spreadsheet widget read only column Image 2 Screenshot 41

    Please give it a try and let us know if you need further assistance.