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

  • Profile Image
    cvaughn
    Asked on October 11, 2018 at 03:53 PM

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



    This is a re-post of a comment on How to Assign Calculation Value

  • Profile Image
    arthurprc
    Answered on October 11, 2018 at 04: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.png

    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!

  • Profile Image
    consultapollo
    Answered on October 17, 2018 at 12:56 AM

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

  • Profile Image
    AshtonP
    Answered on October 17, 2018 at 08: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.

  • Profile Image
    cdedigmaturity
    Answered on November 04, 2018 at 02:45 PM

    Hi Is there any way to export the calculated values in googlesheet rather than the text answers?  
  • Profile Image
    Adrian
    Answered on November 04, 2018 at 04: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