# Adding up values

**URL:** https://community.glideapps.com/t/adding-up-values/37966
**Category:** Ask for Help
**Created:** [February 1, 2022, 10:17am UTC](https://community.glideapps.com/t/adding-up-values/37966 "2022-02-01T10:17:59Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Walleya](https://avatars.discourse-cdn.com/v4/letter/w/3da27b/32.png) [@Walleya](https://community.glideapps.com/u/Walleya)
#### Post date: [February 1, 2022, 10:17am UTC](https://community.glideapps.com/t/adding-up-values/37966/1 "2022-02-01T10:17:59Z")

</div>

Hello all

I have a form which incudes 2 money values - i want to be able to add these up together and put the total into a new column in Google sheets

I have seen the Math column but this is not adding it back to the destination google sheet.

any advise would be appreciated.

Thanks

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [February 1, 2022, 12:48pm UTC](https://community.glideapps.com/t/adding-up-values/37966/2 "2022-02-01T12:48:23Z")

</div>

I would add a `Set Column` action to the `On Submit` setting of the form button:

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 2, 2022, 12:32am UTC](https://community.glideapps.com/t/adding-up-values/37966/3 "2022-02-02T00:32:08Z")

</div>

An alternative is to use Google Sheet’s arrayformula, if you have to have that value in the Sheets. Computed columns (including Math) won’t show up in the Sheet.

> [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727):
>
> Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 
> 
> > **1/ Definition**
> >
> > Arrayformula is defined as “a range, mathematical expression using one cell range …