Hi guys i would like to collect data on what you can do with math. If there is any other way to calculate things besides +,-,*,/ I feel like this info is missing in glide. Lets say i want to calculate how many times a name is appeared over again. would that be possible? Compare a col to another. If…

[image] Math Column Performs instant calculations on your data There are a few others (date and scientific calculation related), but that’s most of them. There’s quite a few posts that touch on the different things you can do, but if I think of it, I’ll try …

OK just to understand the functions. I would like to calculate a col with the same names with another col. if it has the same name count row 1,2,3. Something similar to this. =ARRAYFORMULA(if(ISBLANK(B2:B) <= false,COUNTIFS($K2:$K&B2:B,""&$K2:$K&B2:B,ROW($B2:$B),"<="&ROW($B2:$B)),0)) And this =AR…

[image] Find from a list from within a form Ask for Help I’ll watch your video later, but have you tried creating relations and then create rollups on top of that relation to get your unique counts? I don’t think you would need math column to do simple counts. Just r…

I agree However when comparing 2 items together it wont work with relation and rollups. you may need another solution. Let me explain. Lets say you have col A with users Email, In col B you have Products that you soled to your costermore. If you want to compare how many Products where sold by ea…

Yes, there is a solution - templates. Create a template column that concatenates the customer name and product, then relate that template column to itself. Then do a rollup through that relation to get a count. This is bread and butter stuff when it comes to Glide computed columns. Dig out a few …

Thank you, Yes that solution helped. Going to make research and watch Bob Petitto’s tutorials. I am still not convinced we have everything covered but i am hoping to be proven wrong after watching his videos. And even if we do have a solution for everything, the steps to get there for each results a…

[image] abe.sherman: Now lets say i want a number count down 1,2,3,4,5,6,7 For the reason i want to show only 1 item of the same exacts match. Filter; If rollup is 1 Then show only 1. of the many listed. Or even better if Rollup is = last, or max of the listed. In this case, a rollup column i…

Kind of agree. As a lifelong developer, doing things in glide is much easier than doing it with hundreds of lines of code. Some things may take a handful of columns to accomplish, but it also provides the ability to create an almost endless list of possible functions. I think if Glide provided ve…

What are all formula you can use with math?

Ask for Help

Jeff_Hager July 5, 2021, 5:00pm 4

I don’t think you would need math column to do simple counts. Just relations and rollups.

Topic		Replies	Views
Can we create an array COUNTIFs formula within Glide Ask for Help	4	2140	February 14, 2021
New computed column: Math General	95	6458	November 12, 2021
Filter visibility by Character Count! Feature Requests	18	1888	January 23, 2022
Countif in Glide Table Ask for Help	15	1107	April 25, 2022
Row Rollup Feature Requests	8	689	September 6, 2020

What are all formula you can use with math?

Related topics