# New computed column: Math **URL:** \ **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:** 17\ **Page:** 5
**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:** [May 16, 2020, 7:06pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/81 "2020-05-16T19:06:59Z")
That’s right. Getting it to work in the spreadsheet is super simple. However, in this case the lag in calculation completely destroys the user experience. There needs to be instant calculations so users can instantly see which times are available or not. Otherwise I’ll get double bookings. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 16, 2020, 7:11pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/82 "2020-05-16T19:11:54Z")
Understood. That makes perfect sense if you are using your date calculation within the use case of a booking. Addition and subtraction of numbers is available. It seems like it is only a question of time until you can compute other objects such as dates or time. 🙂 🤞 ---
**Author:** ![Heber\_Medina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heber_medina/32/8007_2.png) [@Heber\_Medina](https://community.glideapps.com/u/Heber_Medina)\ **Post date:** [May 26, 2020, 7:00pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/83 "2020-05-26T19:00:27Z")
I really like this feature, awesome work and all the updates that followed. Is there anyway to use it with columns from different sheets in the file. Thanks! ---
**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:** [May 26, 2020, 11:33pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/84 "2020-05-26T23:33:38Z")
Hi Heber, I think you can use relations & lookups to get those columns into the same sheet within Glide editor. Then you can compute something new from them. ---
**Author:** ![Heber\_Medina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heber_medina/32/8007_2.png) [@Heber\_Medina](https://community.glideapps.com/u/Heber_Medina)\ **Post date:** [May 30, 2020, 11:58am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/85 "2020-05-30T11:58:51Z")
Hey, thanks so much. It worked perfectly! 👍 ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [January 13, 2021, 7:54pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/86 "2021-01-13T19:54:38Z")
I used the MATH field to compute a revised date based on U.S. Eastern Time in place of UTC. Calculation works and the data are in the Glide table and display in the app builder. But, the data do not show up in the live app. I get a hazy gray line. Something going on here? Ideas welcome. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 13, 2021, 10:26pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/87 "2021-01-13T22:26:39Z")
What do you mean by a hazy gray line? Do you have a screenshot? ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [January 13, 2021, 10:46pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/88 "2021-01-13T22:46:11Z")
Screenshots attached. ![Screen Shot 2021-01-13 at 2.44.54 PM (2)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/c/4cdd0aa38e38dc230b3993da53538ea5b292dc8c.jpeg) ![Screenshot 2021-01-13 at 2.41.18 PM_phone](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/51726914472776f5e0e3e933dfc822d3904ad962.jpeg) ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [January 13, 2021, 11:03pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/89 "2021-01-13T23:03:01Z")
That’s progressive bar Can you share what column you’re picked to show the results on it? ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [January 13, 2021, 11:21pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/90 "2021-01-13T23:21:12Z")
A MATH column that changes a datetime calculation. (takes a datetime and subtracts five hours from it) ---
**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:** [January 13, 2021, 11:25pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/91 "2021-01-13T23:25:59Z")
Looks like a bug to me. Probably you can contact support about this. ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [January 14, 2021, 1:04am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/92 "2021-01-14T01:04:41Z")
Lucas, what do you think? ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [January 14, 2021, 1:59am UTC](https://community.glideapps.com/t/new-computed-column-math/1963/93 "2021-01-14T01:59:29Z")
Resolved. Not sure how. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 12, 2021, 1:55pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/94 "2021-11-12T13:55:42Z")
Is there any chance that we could get an ‘atan2’ function added to the math column? I’m trying to calculate compass bearing between two sets of coordinates. I can kind of hack through it with just the ‘atan’ function, flipping the result 90 degrees, adding 180 depending on direction, and wrapping in an absolute, but the result quickly gets out of whack after a certain distance and starts to flip the bearing around. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [November 12, 2021, 1:59pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/95 "2021-11-12T13:59:40Z")
@Jeff_Hager Hyperformula (and JavaScript) columns have atan2. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [November 12, 2021, 1:59pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/96 "2021-11-12T13:59:43Z")
---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [November 12, 2021, 1:59pm UTC](https://community.glideapps.com/t/new-computed-column-math/1963/97 "2021-11-12T13:59:54Z")
Closing this very old thread! [Previous page](https://community.glideapps.com/t/new-computed-column-math/1963.md?page=4)