# How to number or identify rows while sorting?

**URL:** <https://connect.superhuman.com/t/how-to-number-or-identify-rows-while-sorting/34396>\
**Category:** Ask the Community\
**Created:** [October 6, 2022, 6:09am UTC](https://connect.superhuman.com/t/how-to-number-or-identify-rows-while-sorting/34396 "2022-10-06T06:09:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![yscias](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/yscias/32/29458_2.png) [@yscias](https://connect.superhuman.com/u/yscias)\
**Post date:** [October 6, 2022, 6:09am UTC](https://connect.superhuman.com/t/how-to-number-or-identify-rows-while-sorting/34396/1 "2022-10-06T06:09:50Z")

</div>

Hi, is there a way to number or identify rows automatically whichever way you sort it or manual move the row?

I’m trying to find a way to the the row numbers automatically updated depending on how i sort it, whether by date or manually. I have tried rank and it doesnt work. I managedr to find the Find formula that can be used to number rows sorted by dates. But is there another way to do this? For example, if i need to move the row manually?

https://coda.io/embed/oTkvFUdv1o/_suoVd?viewMode=embedplay

---

<div class="post-metadata">

**Author:** ![Quentin\_Morel](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/quentin_morel/32/31407_2.png) [@Quentin\_Morel](https://connect.superhuman.com/u/Quentin_Morel)\
**Post date:** [October 6, 2022, 6:31am UTC](https://connect.superhuman.com/t/how-to-number-or-identify-rows-while-sorting/34396/2 "2022-10-06T06:31:42Z")

</div>

Hi,

I dont understand whyy `Rank()` function would not work in your case ?  
Have a look in the [blog post](https://coda.io/@quentin-morel/qm-plays-with-coda/mastering-rank-n-display-21) i’ve made about mastering rank function, and you can combine it with a “GroupBy/SortBy” Column, [check this out](https://coda.io/@quentin-morel/qm-plays-with-coda/dynamic-group-by-your-table-11)

The idea would be to have a dynamic column calculated with `SwitchIf()`, according to the way you wanna sort, and apply the Rank function to it !

Let me know

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [January 4, 2023, 6:31am UTC](https://connect.superhuman.com/t/how-to-number-or-identify-rows-while-sorting/34396/3 "2023-01-04T06:31:57Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.