Make a column additive in google sheets

I have created a form and integrated google sheets. Everything works well. I was wondering if there was a way to show column Z additive so we can get running totals.

thx

Hi Raj,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

To show column Z as an additive running total in your Google Sheets integration, you can use Google Sheets' built-in formula feature. Here’s how to do it:

1. Open your Google Sheets where your form data is integrated.
2. In a new column, enter a running total formula for column Z. For example, if your data starts in row 2, in the new column's row 2 cell, enter =Z2.
3. In the next row (row 3), enter the formula =previous_running_total_cell + Z3 (e.g., if the running total is in column AA, cell AA2, then in AA3 enter =AA2 + Z3).
4. Drag the formula down the column to apply the running total for all rows.

This will give you a cumulative sum (running total) of column Z values.

Give it a try and let us know how it goes.

Hi Raj,

If you want to add another column with the total amount from the Product List, then you can achieve this by adding a Short Text element on your form, and setting up Update/Calculate/Field conditions. Let me walk you through it:

1. Open your form in Form Builder, click on Add Element, located on the left side of the screen.

2. Under Basic tab, drag and drop a Short Text element on your form.

3. In the blue navigation bar at the top of the page, click on Settings.

4. In the menu that appears on the left side of the screen, click on Conditions, and then select Calculate/Update Field conditions.

5. Now, set the conditions as shown in the screenshot below:

Once you set it up, you can add the Short Text field in the Google Sheet integration settings.

Give it a try and reach out again if you have any other questions.