# Create numeric order in glide sheets
**URL:** https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003
**Category:** Ask for Help
**Created:** [December 17, 2020, 6:40pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003 "2020-12-17T18:40:44Z")
**Posts on this page:** 8
**Page:** 2
### Author:  [@Drearystate](https://community.glideapps.com/u/Drearystate)
#### Post date: [December 17, 2020, 7:40pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/21 "2020-12-17T19:40:26Z")
I think it would be almost as easy as flipping a switch from the compund actions button press. Think about it, the code is already there for the trigger to exist if a button is pressed. The same code can be duplicated and setup to trigger if criteria is met, thats all the button press is a crteria of the button being pressed.
---
### Author:  [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)
#### Post date: [December 17, 2020, 7:41pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/22 "2020-12-17T19:41:07Z")
Yes this could be a game changer for so many things. Especially this specific use case.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 17, 2020, 7:45pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/23 "2020-12-17T19:45:24Z")
That would be awesome!
(This response applies to both or your posts @Drearystate, @Manan_Mehta) 😉
---
### Author:  [@Food2Soil](https://community.glideapps.com/u/Food2Soil)
#### Post date: [January 18, 2023, 10:20pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/25 "2023-01-18T22:20:24Z")
Its been a while since this idea was discussed so wondering if there’s a way to do ranks or increments based on certain conditions. Here’s my use case.
I have a list of 25 locations (say Location A- Location Y) ordered by a column 'Route Stop #‘s’ (1-25). So the google sheet looks like this:
Stop # Location Name
1 Location A
2 Location B
Some locations are on or off the route for the week. I want a dynamic column which generates another number based on where that location falls on that week’s route. For for e.g. Say location B which is master route stop # 2 is not on this week’s route. In that case I want a dynamic column which assigns #2 to Location C.
I’m sure there is an elegant way to do this. Am hoping someone can help. Thanks in advance!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [January 19, 2023, 12:40am UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/26 "2023-01-19T00:40:41Z")
I don’t quite follow your route use case, but this is one the simplest ways to add an auto increment.
> [@Problem with displaying images](https://community.glideapps.com/t/problem-with-displaying-images/43460/5):
>
> It works like so:
>
> - Create a bare Glide table to use as a helper table
> - Add a RowID column
> - Add a Lookup column that targets the RowID column. The result should be an array of RowIDs.
> - Use a Find Element Index column to find the RowID in the RowID array. This will give you an auto-incrementing Row Index.
> - Add your Image array using a Single Value column, or relation + lookup column.
> - Now use a Single Value column to address the Nth from start of the image array, where N is the row index.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [January 19, 2023, 1:26am UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/27 "2023-01-19T01:26:10Z")
yeah, if I’m understanding the use case correctly then a variation of that should do it.
@Food2Soil - assuming that you have a boolean column that defines the status for each stop (in/out), then all you should need to do is create a relation to your list of Stops (using the boolean as a filter), then add a lookup to create an array of StopIDs via the relation, then expand the array using the RowID/Single Value method.
If you then need details related to each stop, you’d create a single relation back to your stops table, and add whatever lookup columns are necessary.
---
### Author:  [@Food2Soil](https://community.glideapps.com/u/Food2Soil)
#### Post date: [January 20, 2023, 8:22pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/28 "2023-01-20T20:22:26Z")
Thankyou @Darren_Murphy and @Robert_Petitto for your help. Both solutions worked!
---
### Author:  [@Janeer](https://community.glideapps.com/u/Janeer)
#### Post date: [January 27, 2023, 10:42am UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/29 "2023-01-27T10:42:54Z")
Good examples, I also had some problems with numeric order in Glide. Now all is fine. Thanks!
new project more
[Previous page](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003.md?page=1)