Additional column for money due

  • Profile Image
    Asked on February 18, 2016 at 06:23 AM

    The Excel spreadsheet generated by Jot Form for my musical camp has a column that states what tuition option the attendee is signing up for, it looks like this:

    All-Inclusive Double Occupancy (Amount: 490.00 USD)
    Discount: -30.00
    Total: 460.00
    Coupon used: MUC30

    Is there a way to generate an additional column that shows only the dollar amount due ($460 in this example) without any other text? That would make it easy to sum the total amount of money due so we can reconcile it with our Pay Pal payments. 

    Thank you!

  • Profile Image
    Answered on February 18, 2016 at 11:17 AM

    You can add additional column with hidden field.

    It will add $ sign automatically on your Google Spreadsheets Integration.

    Here is how it works:

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.