# Column Type for Range Between 2 Numbers
**URL:** https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218
**Category:** Ask for Help
**Created:** [October 21, 2022, 8:30pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218 "2022-10-21T20:30:33Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@spencerb](https://community.glideapps.com/u/spencerb)
#### Post date: [October 21, 2022, 8:30pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/1 "2022-10-21T20:30:33Z")
Hi, I’m trying to figure out which column type to choose for a column that has numbers in it. I have 4 different groups: well below benchmark, below benchmark, at benchmark, and above benchmark. Take a look at this screenshot…
I’m trying to configure the column type to where if a number in a column is in between the range, then it will give me a certain emoji. I tried using if\_then column type, but then realized that it doesn’t really give me the ability to stop at a certain number. For example, I can choose greater than or equal to a certain number, but I can’t necessarily tell it which number to stop at so that it doesn’t go beyond the range I want it to focus on. Does that make sense?
Could use some help with this one. Thanks so much for your time.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 21, 2022, 9:28pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/2 "2022-10-21T21:28:59Z")
IF-ELSE column has multiple criteria… start from well below and end at the above benchmark…
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 21, 2022, 10:54pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/3 "2022-10-21T22:54:10Z")
Hey Spencer! Congrats on being a Glide Ambassador, BTW.
@Uzo’s way should work—I’ve use that method in the past, but now I do something different.
Recently, I did something sim similar when determining a user’s rank (between a minimum and maximum amount of XP). It’s not super simple, but it’s super flexible and prevents you from needing to use if-then-else columns.
> **[Loom Message - 21 October 2022](https://www.loom.com/share/8fa71d2d12604796b7bcd461ec939e2d)**
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 21, 2022, 11:06pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/4 "2022-10-21T23:06:35Z")
actually is very simple LOL…
> **[StructureArt's App testing](https://sa-test2.glideapp.io/)**
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 21, 2022, 11:09pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/5 "2022-10-21T23:09:00Z")
Right, that’s what I was saying—it’s easy if you know those numbers will never change. However, If for some reason you need to edit the thresholds, you’ll need to go back in and edit ALL those ITE columns.
That’s what I love about Glide—more than one way to solve the problem 🙂
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 21, 2022, 11:09pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/6 "2022-10-21T23:09:56Z")
can you just put it as a variable in the if-else column???
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 21, 2022, 11:10pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/7 "2022-10-21T23:10:55Z")
possibly…you’d need to create single value columns for each variable…in the end, probably more columns than the 6 I was proposing, though.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 21, 2022, 11:11pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/8 "2022-10-21T23:11:28Z")
One for each column… and you can create a nice CSS table… your method is great for a big number of benchmarks… but it will not give you the option to create a 2D table…
---
### Author:  [@spencerb](https://community.glideapps.com/u/spencerb)
#### Post date: [October 22, 2022, 2:14am UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/9 "2022-10-22T02:14:06Z")
Bob, thank you SOOOO much! It makes total sense with how you explained it. Off to create some columns. Appreciate your time, sir!
And Uzo, thanks for your suggestion as well. I might see play with that to see if I like that solution better. Thanks for your time!
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 22, 2022, 2:17am UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/10 "2022-10-22T02:17:13Z")
there is a link under the images to the live sample…
---
### Author:  [@spencerb](https://community.glideapps.com/u/spencerb)
#### Post date: [October 22, 2022, 2:17am UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/11 "2022-10-22T02:17:59Z")
Ahhh, thank you. Checking it out now.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 22, 2022, 6:10pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/12 "2022-10-22T18:10:50Z")
I add a **clickable** CSS inline list table… LOL
[](https://sa-test2.glideapp.io/)
> **[StructureArt's App testing](https://sa-test2.glideapp.io/)**
I always want to do it… 😉
Who knew… you can actually create a nice table from the inline list…
---
### Author:  [@spencerb](https://community.glideapps.com/u/spencerb)
#### Post date: [October 24, 2022, 1:34pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/13 "2022-10-24T13:34:35Z")
Ok, I’m getting an error message now in a number of columns, which has rendered Bob’s solution useless now. It was working perfectly this weekend, so I’m thinking it has something to do with Glide, and not the way they’ve been set up. Here’s the screenshot below. When I click on Reload, nothing happens. When I click on Learn More, the page won’t open, but it points to this → [https://www.glideapps.com/docs/experimental-code-column](https://www.glideapps.com/docs/experimental-code-column).
Any idea what might be going on here?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 24, 2022, 1:44pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/14 "2022-10-24T13:44:38Z")
What type of column is BOY\_index?
I just had a quick look at Bob’s video, and it looks like it might be the Find Element Index plugin?
That error indicates that the plugin isn’t loading correctly. What happens if you re-create the column?
---
### Author:  [@spencerb](https://community.glideapps.com/u/spencerb)
#### Post date: [October 24, 2022, 2:06pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/15 "2022-10-24T14:06:36Z")
Well, it’s just a Sort Array column. Is that a plugin? I didn’t think it was. Let me try recreating it. It’s weird though. None of those column types that Bob showed in his video, and the ones I was able to use, are coming up for me. They’re completely gone. Only one still there is Make Array.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 24, 2022, 2:10pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/16 "2022-10-24T14:10:53Z")
Yes, it is a plugin. You can tell that by the column type:
All the plugin columns will appear as “Experimental Code” type.
I don’t think it’s a Glide bug, because if the plugins had suddenly broken then we’d all be affected. More than likely it could be related to your network, or the state of your browser.
If re-creating the column doesn’t help, try reloading the builder. And if that doesn’t work, try removing all Glide related cookies and then login again.
---
### Author:  [@spencerb](https://community.glideapps.com/u/spencerb)
#### Post date: [October 24, 2022, 2:14pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/17 "2022-10-24T14:14:46Z")
Can you send me a screenshot of what your menu displays when you hover over Other. When I click on Experimental Code, the page is still not loading for me. Is it loading for you? My internet is otherwise working great. I’m getting a 404.
[https://www.glideapps.com/docs/experimental-code-column#caveats](https://www.glideapps.com/docs/experimental-code-column#caveats)
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 24, 2022, 2:17pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/18 "2022-10-24T14:17:18Z")
> [@spencerb](#):
>
> Can you send me a screenshot of what your menu displays when you hover over Other.
Do you mean this?
> [@spencerb](#):
>
> When I click on Experimental Code, the page is still not loading for me. Is it loading for you?
I’m not sure what you’re referring to. Click where?
---
### Author:  [@spencerb](https://community.glideapps.com/u/spencerb)
#### Post date: [October 24, 2022, 2:21pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/19 "2022-10-24T14:21:08Z")
Yes, when hovering over Other, you have a bunch of options under the Experimental heading. I’m not seeing all of those options any more. The only option in there for me is Code, and then Experimental Code, and nothing else. Weird.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 24, 2022, 2:22pm UTC](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218/20 "2022-10-24T14:22:28Z")
Okay, sounds like your builder is in a “broken” state. I’d suggest trying the below:
> [@Darren\_Murphy](#):
>
> If re-creating the column doesn’t help, try reloading the builder. And if that doesn’t work, try removing all Glide related cookies and then login again.
[Next page](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218.md?page=2)