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.
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. 
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!
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.
Hey, thanks so much.
It worked perfectly! 
1 Like
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.
What do you mean by a hazy gray line? Do you have a screenshot?
That’s progressive bar
Can you share what column you’re picked to show the results on it?
A MATH column that changes a datetime calculation. (takes a datetime and subtracts five hours from it)
Looks like a bug to me. Probably you can contact support about this.
1 Like
Lucas, what do you think?
Resolved. Not sure how.
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.
Closing this very old thread!
2 Likes