# Glide / Google Gods - Solve This Please **URL:** \ **Category:** Ask for Help\ **Created:** [December 9, 2020, 8:46am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605 "2020-12-09T08:46:27Z")\ **Posts on this page:** 20\ **Page:** 1
**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:** [December 9, 2020, 8:46am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/1 "2020-12-09T08:46:27Z")
In my User Profile sheet I have 9 columns each of which holds a score e.g. 7,3,8,2,1,5,9,3,5. I would just like to have another column that specifies which of these columns holds the lowest value. Simple right? I wish … ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [December 9, 2020, 8:54am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/2 "2020-12-09T08:54:01Z")
A query + MIN formula would work well here I bet!! Hang on. I can probably find something on Google. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 9, 2020, 8:54am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/3 "2020-12-09T08:54:09Z")
So you want to identify the _name_ of the column that holds the lowest value, as opposed to just grabbing the lowest? ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [December 9, 2020, 8:54am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/4 "2020-12-09T08:54:51Z")
Ahh didn’t catch that last part. Hmm. ---
**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:** [December 9, 2020, 8:55am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/5 "2020-12-09T08:55:06Z")
I think the issue here is that MIN does not play nicely inside an ARRAYFORMULA ---
**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:** [December 9, 2020, 8:55am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/6 "2020-12-09T08:55:20Z")
Ideally yes ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [December 9, 2020, 8:56am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/7 "2020-12-09T08:56:11Z")
Yeah it doesn’t. A QUERY formula would maybe work okay but it would be a complex one. ---
**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:** [December 9, 2020, 8:56am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/8 "2020-12-09T08:56:43Z")
For context, these are scores in various assessment categories and I want to offer advice based on the lowest score(s) ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [December 9, 2020, 8:58am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/9 "2020-12-09T08:58:50Z")
Okay here’s an example thread I found— just ignore the average and max! [Finding Average, maximum and minimum value from multiple columns](https://support.google.com/docs/thread/11619638?hl=en) ---
**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:** [December 9, 2020, 9:01am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/10 "2020-12-09T09:01:16Z")
Ouch! Bit early in the morning for the query statement! But I will grab and coffee and try it - thanks. ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [December 9, 2020, 9:05am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/11 "2020-12-09T09:05:50Z")
LOL! Query is a bit of a beast for sure. If you can share an example sheet or just tell me which columns you’re needing to group by, I can try to help! ---
**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:** [December 9, 2020, 9:11am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/12 "2020-12-09T09:11:04Z")
Well as an example, assume you have a single row with 9 columns. The column values are 3,6,2,7,8,9,4,3,2 for example. Can QUERY be used to calc the value of the lowest column value and put this in the 10th column? At first glance it seems that QUERY wants to do its work across multiple rows rather than within a row, but I have never used it before so am probably wrong. ---
**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:** [December 9, 2020, 9:11am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/13 "2020-12-09T09:11:46Z")
If this worked then I guess I’d use an array formula to replicate down as new rows are added? ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [December 9, 2020, 9:14am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/14 "2020-12-09T09:14:34Z")
Query is kind of like an arrayformula itself. It should compute new data from whatever columns you name. And yes, you’re right in saying that QUERY works across multiple rows, but it also works across multiple columns, if you write it like that. Hang on & I’ll share a sheet w/ an example. ---
**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\ **Post date:** [December 9, 2020, 9:36am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/15 "2020-12-09T09:36:32Z")
Here’s an open edit sheet, so feel free to poke around— but this uses several diff formulas w/a query. It expands when new rows are added. Only downside, I didn’t identify which column contains lowest value. Try playing around with it (maybe using “Label” and “Group by” language) to solve that part! [Query to find MIN across columns](https://docs.google.com/spreadsheets/d/1HLN8fuTbyPzlg9sqqPBXPKr94MD8TP0r8_K5HM3CkJw/edit) ---
**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:** [December 9, 2020, 9:39am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/16 "2020-12-09T09:39:59Z")
Much appreciated. Will take a look now that coffee has hit. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 9, 2020, 9:42am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/17 "2020-12-09T09:42:27Z")
I will jump in and help if the solution has not been found. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 9, 2020, 9:49am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/18 "2020-12-09T09:49:15Z")
I knew you would show up sooner or later 😂 ---
**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:** [December 9, 2020, 9:55am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/19 "2020-12-09T09:55:14Z")
I will politely decline any further response to that comment sir … ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [December 9, 2020, 9:59am UTC](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605/20 "2020-12-09T09:59:27Z")
Why not do it inside Glide Date Editor itself? You could use a Math column with the formula Min(Col A, Col B, …, Col I) Lets call this column “Min Val” Now from that use another If Then Else Column with conditions if Min Value equals value in Col A, Return Col A If Min Value equals value in Col B, Return Col B and so on. That’s the simplest way I could think of. Btw what @MegannLock did with the Query blew my mind 🤯 [Next page](https://community.glideapps.com/t/glide-google-gods-solve-this-please/19605.md?page=2)