🧮 New Math functions

:new: The Math Column now supports many more functions such as TRUNC, ASIN, COS, ROUND & MOD. :abacus: We, therefore, did the sensible thing and rounded down all the birthdates in our employee directory so everyone’s much younger! :baby: :wink:

26 Likes

Wonderful! @JackVaughan!

1 Like

@JackVaughan thanks to you & the Glide Team!

1 Like

Thank you so much for this

Wow, good job

thank you for the update

Gideon

This is great, thanks !

Great work! Glide keeps getting better and better.

3 Likes

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.

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

4 Likes

Sorry, I only know a few of those nominations…

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

4 Likes

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

4 Likes

Thank you so much man!

1 Like

How do you suppose to do it, Bob?

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. :wink: 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.

5 Likes

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.

4 Likes

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

3 Likes

@V88_Google… sure! @Mark has just told me he has added them and will release on Thursday. :wink:

8 Likes

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! :rofl: :joy:

3 Likes

I hope you passed your Experts test legitimately @eltintero :wink:

5 Likes

:joy: :joy: