How do I import an excel file that does calculations.

  • margie mechanic
    Asked on May 20, 2020 at 11:19 AM

    How do I import an excel file that does calculations. for example:

    Number of Bridesmaids cost per service sum

    3 100 300

    Number of Flower gls cost per service sum

    2 50 100

    Total Fee 400

  • Patrick_R
    Replied on May 20, 2020 at 12:55 PM

    Hi Margie! Let me look into this. I'll get back to you with an update shortly.


    Thank you!

  • Patrick_R
    Replied on May 20, 2020 at 1:23 PM

    Hi Margie, If you're trying to import submissions from an Excel File that has Formulas implemented, then it should be possible for you to import it without any extra changes. For the demonstration purposes, I have created the following screencast that imports an Excel file that has a Row to calculate the SUM of the adjoining cells.

    1589995360Screencast 2020 05 20 22 47 59 Screenshot 10

    I hope this answers your query. In case it doesn't or for any further queries, feel free to get back to us.