# Add row #s when grouped? **URL:** \ **Category:** Ask the Community\ **Created:** [May 13, 2021, 2:57am UTC](https://connect.superhuman.com/t/add-row-s-when-grouped/23394 "2021-05-13T02:57:10Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [May 13, 2021, 2:57am UTC](https://connect.superhuman.com/t/add-row-s-when-grouped/23394/1 "2021-05-13T02:57:10Z")
Hi! Coda automatically adds row numbers to tables…until you add a group. Is there anyway to add row numbers using a formula or some other function? Many thanks! Gregg ---
**Author:** ![joost\_mineur](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/joost_mineur/32/30539_2.png) [@joost\_mineur](https://connect.superhuman.com/u/joost_mineur)\ **Post date:** [May 13, 2021, 7:53am UTC](https://connect.superhuman.com/t/add-row-s-when-grouped/23394/2 "2021-05-13T07:53:35Z")
Hello Gregg, When you group rows, the original row number has no meaning anymore, since grouping also changes the sorting of your rows. There are a lot of ways to give your row a number, like with RowID() or Rank(), they can show after the rows are grouped, but they won’t have much meaning anymore, other than perhaps locating them in the originating table. What are you trying to achieve? Greetings, Joost ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [May 13, 2021, 8:16am UTC](https://connect.superhuman.com/t/add-row-s-when-grouped/23394/3 "2021-05-13T08:16:06Z")
Hi, Joost…thank you for your reply! I have a list of items that we sort and group various ways as we process each list…having row numbers would be useful just so you know you’re on row 27 of 100 or if you’re on row 27 and need to move to another place in the list, it’s easy to get back to row 27. So it’s a convenience thing and a visual thing. I was hoping there might be a way to add a column with row numbers that would be generated dynamically based on the criteria of the current view that would include sorting, filtering and even control values. Thanks for any ideas or help you might be able to offer! ---
**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\ **Post date:** [May 13, 2021, 5:57pm UTC](https://connect.superhuman.com/t/add-row-s-when-grouped/23394/4 "2021-05-13T17:57:32Z")
Hey there @Gregg_Stebben I think this document is doing what you are looking for. With filtering at least, haven’t tried it out with grouping yet. [DOC LINK](https://coda.io/d/computer_dobs8dFIw49) https://coda.io/embed/obs8dFIw49/_su6L-?viewMode=embedplay ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [May 14, 2021, 12:24pm UTC](https://connect.superhuman.com/t/add-row-s-when-grouped/23394/5 "2021-05-14T12:24:27Z")
Hey @Scott_Collier-Weir …thank you! I look forward to trying this!! I will let you know if I can make it work with groups!! ---
**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\ **Post date:** [May 16, 2021, 8:08pm UTC](https://connect.superhuman.com/t/add-row-s-when-grouped/23394/6 "2021-05-16T20:08:16Z")
@Gregg_Stebben any chance you got it to work? ---
**Author:** ![Gregg\_Stebben](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/gregg_stebben/32/597_2.png) [@Gregg\_Stebben](https://connect.superhuman.com/u/Gregg_Stebben)\ **Post date:** [May 17, 2021, 5:47am UTC](https://connect.superhuman.com/t/add-row-s-when-grouped/23394/7 "2021-05-17T05:47:04Z")
No…but I am still messing with it! ---
**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\ **Post date:** [May 17, 2021, 6:09am UTC](https://connect.superhuman.com/t/add-row-s-when-grouped/23394/8 "2021-05-17T06:09:18Z")
Have you tried `find(thisrow,thistable)`? ---
**Author:** ![Nurlan\_A](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/nurlan_a/32/21233_2.png) [@Nurlan\_A](https://connect.superhuman.com/u/Nurlan_A)\ **Post date:** [June 26, 2023, 12:56pm UTC](https://connect.superhuman.com/t/add-row-s-when-grouped/23394/9 "2023-06-26T12:56:16Z")
This formula does not work with groups