# New computed column: Math

YES! Awesomeness!

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).

You can set it up in the sheet, but doing it there has a bunch of disadvantages:

- 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.
- Doing it in the spreadsheet is not trivial. You need to know
`ARRAYFORMULA`

and a bunch of tricks to make it work dependably. - If you do it in Glide then you have less data in your spreadsheet, which makes them reload faster.

bravo

Good points! Thanks!

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.

Thank you! Did some learning with formulas when working on my app. But thereās no denying how simple this makes things!

Thatās a good news ! good job team ! thank you

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!

These rapid new feature deployments have been nothing short of incredible @Mark. Cheers to you and the glide team ! Keep up the great work!

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.

The computed columns automatically apply to all rows. Is it not working for you?

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.

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.

@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?

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.

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!

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!

Ah great! That did the trick!