# Create numeric order in glide sheets **URL:** \ **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:** 20\ **Page:** 1
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 6:40pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/1 "2020-12-17T18:40:44Z")
This is more of a question than anything else. Has anyone come up with a way to create a numeric order in a column using just Glide sheets? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 6:52pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/2 "2020-12-17T18:52:36Z")
To be more specific has anyone found a way say for example to number items in a list using only Glide sheets? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 17, 2020, 6:55pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/3 "2020-12-17T18:55:07Z")
I wish we had this as a simple column option. You could technically do it when adding new rows by passing a max value and write it to a new row along with an increment, but it’s a little clumsy and won’t renumber previous rows if you happen to delete a previous row. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 6:56pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/4 "2020-12-17T18:56:30Z")
If the values are only in Glide sheets how can you pass a max value to it? Let’s say your adding a row in forms, you add a numeric value thats not visible to the person entering in would you use a rollup column to get your max value that you have listed as max value and increment from the rollup and the rollup refers to the current values listed from a if then that displays a 1 if not empty a zero otherwise? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 7:02pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/5 "2020-12-17T19:02:31Z")
Like This? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fbd867d6c478278d5044f9fa327f52d9fdf63d93.png) Then increment from there? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 17, 2020, 7:04pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/6 "2020-12-17T19:04:22Z")
I would either create a relation/rollup or a straight rollup on the user profile sheet or the sheet of the detail screen that contains the form button. You could probably then create a math column to add 1 to that rollup. Then pass it through column values in the form directly to the sheet that you are writing the form to. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 7:05pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/7 "2020-12-17T19:05:36Z")
Hmmmm…ok, how can I remove rows when they are done to prevent a ton of empty rows? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 17, 2020, 7:09pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/8 "2020-12-17T19:09:57Z")
You mean when a row is deleted through the app? You’d have to run a script to compact the rows. Be careful though, I think it causes weird things to happen of someone is viewing the app when it’s ran. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 7:10pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/9 "2020-12-17T19:10:35Z")
I need to create a dynamic numeric order. I don’t think this will work. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 7:11pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/10 "2020-12-17T19:11:24Z")
No, I want the entire system to exist only in Glide sheets. All formulas and actions are only in sheets. Nothing in Google. ---
**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 17, 2020, 7:14pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/11 "2020-12-17T19:14:25Z")
How are rows being added in this tab? Is it through a Glide form? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 7:14pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/12 "2020-12-17T19:14:47Z")
currently yes, but can be done otherwise, I’m just starting this idea. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 7:16pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/13 "2020-12-17T19:16:02Z")
The goal here is to create a dynamic looped timer that rotates people in a list that can also be removed and when removed the timer restarts. Or if the timer ends it rotates a name to the bottom and restarts on it’s own. It might take 30 columns to recreate this formula but I will get it figured out. I can do it in excel with 3 cells of 40 character long formulas, I can do it in sheets with the same, and it only takes 15 lines of code in google scripts. Glide is the next attempt. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 17, 2020, 7:26pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/14 "2020-12-17T19:26:20Z")
I thing Glide really needs to create a Rank function. Whether it is it’s own column type, or part of a Math, Rollup, or Single Value column. Something that just works similar to the RowID column and populates automatically. It would also be nice to have options for dynamic renumbering when a row is deleted, as well as static numbers if you want the number to be permanent. Or base it off a relation to get a unique set of ranks within a group. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 7:27pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/15 "2020-12-17T19:27:31Z")
I agree. I requested for a feature that we can make the if then else columns allow us to put compound actions as results of the if then else. That would literally make Glide the most powerful no code solution out there. ---
**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 17, 2020, 7:33pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/16 "2020-12-17T19:33:20Z")
Or maybe a “relate if” column which is similar to sumif and countif ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 17, 2020, 7:34pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/17 "2020-12-17T19:34:51Z")
What would be the trigger to execute the compound action? Just a value change on the row or a change in the resulting condition of the IF THEN? Just brainstorming what would prevent the actions from running over and over again unnecessarily. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 17, 2020, 7:36pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/18 "2020-12-17T19:36:15Z")
Yes. it could be anything, a value changing somewhere in another sheet, a file uploaded, a timestamp becoming 24 hours old, etc. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 17, 2020, 7:36pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/19 "2020-12-17T19:36:25Z")
@Manan_Mehta YES! I’ve wanted this so bad. > [@Conditional Relations](https://community.glideapps.com/t/conditional-relations/13818): > > I know myself and others have made this case before, but I’d like to mention it again. I think it would be hugely benificial to be able to apply IF conditions within Relation settings. My use case for this is to get the unpaid dollar amount from unpaid invoices. I have invoices for students that, let’s say, are billed monthly. The user creates the billing period for a particular month, and any lessons that have occured within that billing period are automatically included in that invoice. In… ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 17, 2020, 7:38pm UTC](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003/20 "2020-12-17T19:38:57Z")
@Drearystate I imagine it could almost follow similar behind the scenes logic of the API column. [Next page](https://community.glideapps.com/t/create-numeric-order-in-glide-sheets/20003.md?page=2)