How can I get the calculated value to show in an excel report?

  • cvaughn
    Asked on October 11, 2018 at 3:53 PM

    How can I get the calculated value to show in an excel report?

  • arthurprc
    Replied on October 11, 2018 at 4:40 PM

    Once the value is submitted, you can download it as CSV, Excel or PDF.

    Please follow this guide to download.

    Alternatively, you can integrate it directly with Google Sheets.

    1539290042spreadsheet Screenshot 10

    With Google Sheets, the submissions will be automatically uploaded to your Google Drive.

    Let us know if you have further questions, we'll be happy to assist!

  • consultapollo
    Replied on October 17, 2018 at 12:56 AM

    Hello I can't see where the calculations come up with the google sheets?  

  • AshtonP
    Replied on October 17, 2018 at 8:32 AM

    The calculated values are assigned to the field in order to carry out the calculations. The values won't be displayed as they are only meant to be used for a calculation.

    For this reason, you can't see the calculation values in the Excel or in the submission sheet. I apologize for the confusion and thank you for your understanding.

  • cdedigmaturity
    Replied on November 4, 2018 at 2:45 PM

    Hi Is there any way to export the calculated values in googlesheet rather than the text answers?  
  • Adrian
    Replied on November 4, 2018 at 4:09 PM

    @cdedigmaturity,

    Your question has been moved to a new thread and it will be answered there shortly.
    https://www.jotform.com/answers/1632356