# 🧮 New Math functions
**URL:** https://community.glideapps.com/t/new-math-functions/16761
**Category:** General
**Created:** [October 5, 2020, 8:12am UTC](https://community.glideapps.com/t/new-math-functions/16761 "2020-10-05T08:12:00Z")
**Posts on this page:** 20
**Page:** 2
### Author:  [@eltintero](https://community.glideapps.com/u/eltintero)
#### Post date: [October 5, 2020, 4:09pm UTC](https://community.glideapps.com/t/new-math-functions/16761/21 "2020-10-05T16:09:14Z")
that one I did!! hahah
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 7, 2020, 1:51am UTC](https://community.glideapps.com/t/new-math-functions/16761/22 "2020-10-07T01:51:03Z")
Since we’re adding new Math functions, any chance we can get Left(), Right() and Rank() formulas too?! Not sure if left/right are really “Math”, but would be super handy!
---
### Author:  [@wjcv06](https://community.glideapps.com/u/wjcv06)
#### Post date: [October 7, 2020, 2:46am UTC](https://community.glideapps.com/t/new-math-functions/16761/23 "2020-10-07T02:46:59Z")
We need “formulas” for Text like LEFT, RIGHT, SUBSTRING, etc…
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [October 7, 2020, 1:40pm UTC](https://community.glideapps.com/t/new-math-functions/16761/24 "2020-10-07T13:40:39Z")
What are you using LEFT, RIGHT, SUBSTRING for?
---
### Author:  [@Bruno\_Sia](https://community.glideapps.com/u/Bruno_Sia)
#### Post date: [October 7, 2020, 1:46pm UTC](https://community.glideapps.com/t/new-math-functions/16761/25 "2020-10-07T13:46:12Z")
Amazing, now waiting for conditional maths expressions, using IF conditions.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 7, 2020, 1:50pm UTC](https://community.glideapps.com/t/new-math-functions/16761/26 "2020-10-07T13:50:05Z")
I’m not using substring (though maybe I should?). `Left()` and `Right()` I use often with `Find()` to create strings from parts of strings ([robert.petitto@email.com](mailto:robert.petitto@email.com) -\> robert.petitto). Sometimes I’ll grab just the first letter of a Last Name to create a user name (Robert P.).
Really, though, more than `Left()` and `Right()`, I’d love the `ENCODEURL()` function to percent encode a string or if there was someway to get the `Base64` version of a string/URL as well that would be amazing.
---
### Author:  [@wjcv06](https://community.glideapps.com/u/wjcv06)
#### Post date: [October 7, 2020, 3:40pm UTC](https://community.glideapps.com/t/new-math-functions/16761/27 "2020-10-07T15:40:12Z")
For example to get the first letter of the user name and create a directory grouped by letter.
For an 8 letter code if you need the positions between 4 and 7, SUBSTRING would be very helpful.
---
### Author:  [@V88](https://community.glideapps.com/u/V88)
#### Post date: [October 8, 2020, 9:00pm UTC](https://community.glideapps.com/t/new-math-functions/16761/28 "2020-10-08T21:00:19Z")
Hey @JackVaughan did this happen yet? Cheers.
---
### Author:  [@kabookie](https://community.glideapps.com/u/kabookie)
#### Post date: [October 8, 2020, 9:46pm UTC](https://community.glideapps.com/t/new-math-functions/16761/29 "2020-10-08T21:46:26Z")
My algebra classes were so long ago that those brain cells seem to be in a dormant state ATM…
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [October 8, 2020, 11:08pm UTC](https://community.glideapps.com/t/new-math-functions/16761/30 "2020-10-08T23:08:30Z")
> [@V88](#):
>
> did this happen yet
It just happened.
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [October 8, 2020, 11:42pm UTC](https://community.glideapps.com/t/new-math-functions/16761/31 "2020-10-08T23:42:02Z")
So,
=CEILING(now(),“00:30”)
or
=CEILING(x,“00:30”) Where x is a GE datetime math column
What is the proper way to structure this? Two separate columns?
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [October 9, 2020, 4:23am UTC](https://community.glideapps.com/t/new-math-functions/16761/32 "2020-10-09T04:23:10Z")
hey @JackVaughan - is there anything unique about the DOB column in the make me younger example, or just a standard datetime column? I get an argument error when I try to replicate.
---
### Author:  [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [October 9, 2020, 10:36am UTC](https://community.glideapps.com/t/new-math-functions/16761/33 "2020-10-09T10:36:15Z")
That looks ok to me. Not sure.
Yes - DOB is just a date/time column formatted with only year.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 9, 2020, 12:04pm UTC](https://community.glideapps.com/t/new-math-functions/16761/35 "2020-10-09T12:04:05Z")
You’re missing a parenthesis after DOB.
---
### Author:  [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [October 9, 2020, 12:07pm UTC](https://community.glideapps.com/t/new-math-functions/16761/36 "2020-10-09T12:07:13Z")
🤦🏼
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 9, 2020, 12:07pm UTC](https://community.glideapps.com/t/new-math-functions/16761/37 "2020-10-09T12:07:30Z")
Happens to the best of us sometimes.
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [October 9, 2020, 4:35pm UTC](https://community.glideapps.com/t/new-math-functions/16761/38 "2020-10-09T16:35:16Z")
I did WHAT? 🙂
Reversing / transposing / omitting things is a regular thing.
Thanks Jeff, and sorry about that @JackVaughan.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 10, 2020, 12:34am UTC](https://community.glideapps.com/t/new-math-functions/16761/39 "2020-10-10T00:34:20Z")
It should just know what we meant, right? 😉
---
### Author:  [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [October 10, 2020, 9:16am UTC](https://community.glideapps.com/t/new-math-functions/16761/40 "2020-10-10T09:16:10Z")
I didn’t see it either! 😉
---
### Author:  [@dinoyonid](https://community.glideapps.com/u/dinoyonid)
#### Post date: [October 18, 2020, 8:49am UTC](https://community.glideapps.com/t/new-math-functions/16761/41 "2020-10-18T08:49:46Z")
For ROUND, is there a way to round to closest integer? (just like MROUND on Google sheets)
i.e I want to round to the closest 500. so 1512 would become 1500 and 1768 would become 2000?
[Previous page](https://community.glideapps.com/t/new-math-functions/16761.md?page=1)
[Next page](https://community.glideapps.com/t/new-math-functions/16761.md?page=3)