# New computed column: Math **URL:** https://community.glideapps.com/t/new-computed-column-math/1963 **Category:** General **Created:** [November 13, 2019, 9:07pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963 "2019-11-13T21:07:22Z") **Posts on this page:** 20 **Page:** 1
### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark) #### Post date: [November 13, 2019, 9:07pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/1 "2019-11-13T21:07:22Z")
![04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9e9af7662ee74b31bd4899f1f7e7f33ea5d0ffa6.gif) ---
### Author: ![Carlos\_DeSilva](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlos_desilva/32/19965_2.png) [@Carlos\_DeSilva](https://community.glideapps.com/u/Carlos_DeSilva) #### Post date: [November 13, 2019, 9:09pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/2 "2019-11-13T21:09:25Z")
šŸ˜„ YES! Awesomeness! ---
### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney) #### Post date: [November 13, 2019, 9:36pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/3 "2019-11-13T21:36:37Z")
I donā€™t want to knock new features, but what is the purpose of this new feature when sheets can handle a variety of mathematical calcs natively? Iā€™m just curious if this is meant to make something else easier (like calcs that involve other related column, etc). ---
### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark) #### Post date: [November 13, 2019, 9:53pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/4 "2019-11-13T21:53:17Z")
You can set it up in the sheet, but doing it there has a bunch of disadvantages: 1. If you do it in Glide the calculation is instantaneous if the user changes the data, whereas with sheet calculations, Glide has to communicate back with the sheet to get the result of the calculation, which can take from a few seconds to a minute or more, depending on how large your spreadsheet is. 2. Doing it in the spreadsheet is not trivial. You need to know `ARRAYFORMULA` and a bunch of tricks to make it work dependably. 3. If you do it in Glide then you have less data in your spreadsheet, which makes them reload faster. ---
### Author: ![GregoryJohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregoryjohn/32/1352_2.png) [@GregoryJohn](https://community.glideapps.com/u/GregoryJohn) #### Post date: [November 13, 2019, 10:07pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/5 "2019-11-13T22:07:07Z")
šŸ‘ bravo ---
### Author: ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney) #### Post date: [November 13, 2019, 10:10pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/6 "2019-11-13T22:10:24Z")
Good points! Thanks! ---
### Author: ![Les\_Henderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/les_henderson/32/1142_2.png) [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson) #### Post date: [November 13, 2019, 11:03pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/7 "2019-11-13T23:03:17Z")
For someone unfamiliar with sheet formulas I found myself stymied by the learning curve complexity of doing something that should be simple. Now Iā€™m ready to dive back in. Thank you for thinking of the masses who may share my ignorance of such things. ---
### Author: ![Mr\_Watkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mr_watkin/32/349_2.png) [@Mr\_Watkin](https://community.glideapps.com/u/Mr_Watkin) #### Post date: [November 13, 2019, 11:59pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/8 "2019-11-13T23:59:53Z")
Thank you! Did some learning with formulas when working on my app. But thereā€™s no denying how simple this makes things! ---
### Author: ![Galinge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galinge/32/989_2.png) [@Galinge](https://community.glideapps.com/u/Galinge) #### Post date: [November 14, 2019, 1:27pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/9 "2019-11-14T13:27:56Z")
Thatā€™s a good news ! good job team ! thank you šŸ’ŖšŸ’ŖšŸ’Ŗ ---
### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo) #### Post date: [November 14, 2019, 1:42pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/10 "2019-11-14T13:42:00Z")
What I always say is: doing heavy stuff in sheets is called no code, but to me thereā€™s not a lof of difference in complexity between coding and some of the formulas. This makes math doable for people like me! Great! ---
### Author: ![fox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fox/32/1176_2.png) [@fox](https://community.glideapps.com/u/fox) #### Post date: [November 14, 2019, 3:11pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/11 "2019-11-14T15:11:42Z")
These rapid new feature deployments have been nothing short of incredible @Mark. Cheers to you and the glide team šŸ»! Keep up the great work! ---
### Author: ![MarkGoosen](https://avatars.discourse-cdn.com/v4/letter/m/f17d59/32.png) [@MarkGoosen](https://community.glideapps.com/u/MarkGoosen) #### Post date: [November 15, 2019, 5:58am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/12 "2019-11-15T05:58:22Z")
Hi there, question regarding the computed column ā€œmathā€, how do I make the formula compute in every new addition of data to my sheet? example I have a dollar rate per kilometer, user enters their address and their destination address, google maps script then calculates the distance. Using ā€œmathā€ Iā€™d like to display the dollar amount based off the calculation ā€œtotal KMā€ multiplied by a set rate. Hope that makes sense. Newbie to all of this. ---
### Author: ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark) #### Post date: [November 15, 2019, 6:07am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/13 "2019-11-15T06:07:21Z")
The computed columns automatically apply to all rows. Is it not working for you? ---
### Author: ![MarkGoosen](https://avatars.discourse-cdn.com/v4/letter/m/f17d59/32.png) [@MarkGoosen](https://community.glideapps.com/u/MarkGoosen) #### Post date: [November 15, 2019, 6:16am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/14 "2019-11-15T06:16:26Z")
Hi Mark, itā€™s displaying the data in the first row (which was a form that was already submitted), but Iā€™d like it to display based on data captured in a new form, so as the user enters their addresses, it displays the rateā€¦however Iā€™ve just realized that itā€™s not going to be possible, as the data need to be submitted to google sheets first, then the google maps script runs to get the distance, then one can only do the calculation - so Iā€™ll just include the rate in the ā€œreal timeā€ email notification that goes out to the customer as oppose to trying to display it in the Glide app as they entering information. ---
### Author: ![Efeosasere\_Okoro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/efeosasere_okoro/32/191_2.png) [@Efeosasere\_Okoro](https://community.glideapps.com/u/Efeosasere_Okoro) #### Post date: [November 15, 2019, 10:30am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/15 "2019-11-15T10:30:46Z")
Nice. Tried it with a google sheet function but it doesnā€™t seem to work. That is, Column A1 = 21/12/2019. I want to calculate how many days to an event. In Google sheet, it wuld be A1-Today(). It will be interesting if this also could work. ---
### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo) #### Post date: [November 15, 2019, 11:21am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/16 "2019-11-15T11:21:20Z")
@Mark To do the math you need the column name, but because of the amount of columns I donā€™t see the full name in the data field. So now I have to go to Google Sheets to look up the name and then make the formula. Is there a way to see the full name from the data view? ---
### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo) #### Post date: [November 15, 2019, 12:01pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/17 "2019-11-15T12:01:25Z")
Question. I have columns with the amount of ā€˜Platenā€™ (records) and ā€˜Boekenā€™ (books), then I calculate the money by multilplying with price in the columns ā€˜Omzet platenā€™ and ā€˜Omzet boekenā€™. So far so good. Now I want to make a total by using the formula ā€˜Omzet platen + Omzet boekenā€™. There I seem to be doing something wrong. Does anyone know what? See screenshot. ![48](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6f71ec8f5872e441d571277c4906ed54e4e691fa.png) ---
### Author: ![Karim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karim/32/13974_2.png) [@Karim](https://community.glideapps.com/u/Karim) #### Post date: [November 15, 2019, 12:52pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/18 "2019-11-15T12:52:10Z")
Hi @erwblo In the field ā€œConfigurationā€ you should try tipping in the following: Omzetplaten+Omzetboeken No spaces are allowed/recognized (had to learn that for an app I am working on atm). Hope this helps! ---
### Author: ![Karim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karim/32/13974_2.png) [@Karim](https://community.glideapps.com/u/Karim) #### Post date: [November 15, 2019, 12:56pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/19 "2019-11-15T12:56:57Z")
Thanks so much for this new feature @mark and team! Itā€™s perfect for a small currency converter app I am working on right now, as well as a personal finance app I already published and can now update šŸ˜ A quick question though (as seen in the GIF tutorial you posted): Every computaion with decimals seems to show up to 16 decimals, which isnā€™t very user friendly šŸ˜… Any tip on how this view can be improved? Thanks! šŸ™ ---
### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo) #### Post date: [November 15, 2019, 1:29pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/20 "2019-11-15T13:29:25Z")
Ah great! That did the trick! [Next page](https://community.glideapps.com/t/new-computed-column-math/1963.md?page=2)