Excel spreadsheet and Input table

  • jharschawf
    Asked on June 25, 2020 at 9:20 AM

    I have the Excel spreadsheet in my report. 


    https://form.jotform.com/201485828579066


    Can you help me with calculations? I need to put both column B and column D totals into the Total $ field and make that a bold and larger font and all those input values should be $ format?


    Also in the form, I have an input table below. I need to calculate both input tables values into Grand Total? Is that possible. If you can help that would be great.
    Page URL: https://form.jotform.com/201485828579066
  • Richie JotForm Support
    Replied on June 25, 2020 at 1:33 PM

    To get the total of the columns, you can use the formula b22= b1 + b2 + d1 + d2  until all the fields in the column are added.

    Excel spreadsheet and Input table Image 10

    Sample screenshot:

    Excel spreadsheet and Input table Image 21

    Regarding the format, it is not possible to add a dollar sign inside the sheets column with the calculation.

    To clarify, do you want to change the fields labels font size or the input?

    Looking forward for your response.