Excel spreadsheet and Input table

  • Profile Image
    jharschawf
    Asked on June 25, 2020 at 09: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.
  • Profile Image
    Richie_P
    Answered on June 25, 2020 at 01: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.

    15931058061.png

    Sample screenshot:

    15931058902.png

    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.