# 🧮 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:** 1

<div class="post-metadata">

### Author: ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [October 5, 2020, 8:12am UTC](https://community.glideapps.com/t/new-math-functions/16761/1 "2020-10-05T08:12:00Z")

</div>

🆕 The Math Column now [supports many more functions](https://docs.glideapps.com/all/reference/data-editor/computed-columns/math-column#supported-calculations) such as TRUNC, ASIN, COS, ROUND & MOD. 🧮 We, therefore, did the sensible thing and rounded down all the birthdates in our employee directory so everyone’s much younger! 👶 😉

 ![Screen Shot 2020-10-01 at 2.19.32 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/17e5048caa93a2e4ae53881b144c8bcd1a7549e6.jpeg)

---

<div class="post-metadata">

### Author: ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)
#### Post date: [October 5, 2020, 8:25am UTC](https://community.glideapps.com/t/new-math-functions/16761/2 "2020-10-05T08:25:16Z")

</div>

Wonderful! @JackVaughan!

---

<div class="post-metadata">

### Author: ![Brad\_Legassick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/brad_legassick/32/8289_2.png) [@Brad\_Legassick](https://community.glideapps.com/u/Brad_Legassick)
#### Post date: [October 5, 2020, 8:35am UTC](https://community.glideapps.com/t/new-math-functions/16761/3 "2020-10-05T08:35:16Z")

</div>

@JackVaughan thanks to you & the Glide Team!

---

<div class="post-metadata">

### Author: ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [October 5, 2020, 8:42am UTC](https://community.glideapps.com/t/new-math-functions/16761/4 "2020-10-05T08:42:13Z")

</div>

Thank you so much for this

---

<div class="post-metadata">

### Author: ![Gideon\_Lahav\_Busines](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gideon_lahav_busines/32/41121_2.png) [@Gideon\_Lahav\_Busines](https://community.glideapps.com/u/Gideon_Lahav_Busines)
#### Post date: [October 5, 2020, 9:06am UTC](https://community.glideapps.com/t/new-math-functions/16761/5 "2020-10-05T09:06:10Z")

</div>

Wow, good job

thank you for the update

Gideon

---

<div class="post-metadata">

### Author: ![Data\_pixel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/data_pixel/32/11818_2.png) [@Data\_pixel](https://community.glideapps.com/u/Data_pixel)
#### Post date: [October 5, 2020, 9:07am UTC](https://community.glideapps.com/t/new-math-functions/16761/6 "2020-10-05T09:07:43Z")

</div>

This is great, thanks !

---

<div class="post-metadata">

### Author: ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)
#### Post date: [October 5, 2020, 9:18am UTC](https://community.glideapps.com/t/new-math-functions/16761/7 "2020-10-05T09:18:48Z")

</div>

Great work! Glide keeps getting better and better.

---

<div class="post-metadata">

### Author: ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)
#### Post date: [October 5, 2020, 9:52am UTC](https://community.glideapps.com/t/new-math-functions/16761/8 "2020-10-05T09:52:56Z")

</div>

Fab work @JackVaughan . Thanks. Are you also planing on DAY, MONTH and YEAR to split out components of a DATE column? That would also be amazing and timely.

---

<div class="post-metadata">

### 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: [October 5, 2020, 10:29am UTC](https://community.glideapps.com/t/new-math-functions/16761/9 "2020-10-05T10:29:10Z")

</div>

Yeah for MOD!!! Now we can do rankings natively in Glide!

---

<div class="post-metadata">

### 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: [October 5, 2020, 11:27am UTC](https://community.glideapps.com/t/new-math-functions/16761/10 "2020-10-05T11:27:02Z")

</div>

> [@JackVaughan](#):
>
> TRUNC, ASIN, COS, ROUND & MOD

Sorry, I only know a few of those nominations…

Can anyone translate them for those who also don’t know?

---

<div class="post-metadata">

### Author: ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)
#### Post date: [October 5, 2020, 11:47am UTC](https://community.glideapps.com/t/new-math-functions/16761/11 "2020-10-05T11:47:26Z")

</div>

Sure. I’m guessing:

TRUNC - truncates to a specific number of digits  
ASIN - inverse sine (trigonometric function for engineering etc)  
COS - cosine (per ASIN)  
ROUND - rounds to a specific number of digits (as opposed to truncating)  
MOD - gives the remainder of a division

---

<div class="post-metadata">

### 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: [October 5, 2020, 12:03pm UTC](https://community.glideapps.com/t/new-math-functions/16761/12 "2020-10-05T12:03:04Z")

</div>

Thank you so much man!

---

<div class="post-metadata">

### 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: [October 5, 2020, 12:03pm UTC](https://community.glideapps.com/t/new-math-functions/16761/13 "2020-10-05T12:03:19Z")

</div>

How do you suppose to do it, Bob?

---

<div class="post-metadata">

### 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: [October 5, 2020, 12:10pm UTC](https://community.glideapps.com/t/new-math-functions/16761/14 "2020-10-05T12:10:06Z")

</div>

Ahh man, but it was so much fun to try to figure out how to accomplish TRUNC functionality in glide with less than 10 columns. 😉 Guess we’ll do it the easy way now. And no more templates to “lock in” rounding with ROUND. I also currently use CEILING in my sheet, so that can be converted.

---

<div class="post-metadata">

### 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: [October 5, 2020, 12:59pm UTC](https://community.glideapps.com/t/new-math-functions/16761/15 "2020-10-05T12:59:46Z")

</div>

Great work team!!  
@JackVaughan can you specify each of those nominations in Glide Library’s page as I asked here? I think it’s important to have it.

---

<div class="post-metadata">

### 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: [October 5, 2020, 1:29pm UTC](https://community.glideapps.com/t/new-math-functions/16761/16 "2020-10-05T13:29:40Z")

</div>

Gr. I can’t find it now. I had the formula bookmarked. I’ll try to find it and share.

---

<div class="post-metadata">

### Author: ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [October 5, 2020, 2:34pm UTC](https://community.glideapps.com/t/new-math-functions/16761/17 "2020-10-05T14:34:34Z")

</div>

@V88… sure! @Mark has just told me he has added them and will release on Thursday. 😉

---

<div class="post-metadata">

### Author: ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)
#### Post date: [October 5, 2020, 3:38pm UTC](https://community.glideapps.com/t/new-math-functions/16761/18 "2020-10-05T15:38:11Z")

</div>

Awesome! Looking forward to what you guys build with this, since I actually didn’t pass my college math tests and had someone do then for me, so I’ve no idea what all of this formulas mean! 🤣 😂

---

<div class="post-metadata">

### Author: ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [October 5, 2020, 3:51pm UTC](https://community.glideapps.com/t/new-math-functions/16761/19 "2020-10-05T15:51:45Z")

</div>

I hope you passed your Experts test legitimately @eltintero 😉

---

<div class="post-metadata">

### 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: [October 5, 2020, 3:51pm UTC](https://community.glideapps.com/t/new-math-functions/16761/20 "2020-10-05T15:51:58Z")

</div>

😂 😂

[Next page](https://community.glideapps.com/t/new-math-functions/16761.md?page=2)
