sorting by row ID

Zafar Yuldashev

Dear Smartsheet users Community members, 

 

can someone answer to my pretty basic question. i have a challenge to sort the table back to initial order per Row ID (1,2,3,4,5,6,7....) after sorting based on some other column info (e.g. date, amount etc). after obtaining certain info based on sorting of different collumns, i want to restore the order by Row ids initially auto assigned. Sorting of Row ID Ascending or Descending only sorts the lines by first numbers like (ROW ID 13, next comes 131, 132) 

Greg Gates

If the column only contains numbers, I'm pretty sure the sort function works correctly. If the column actually contains the text "Row ID 1," then it will do text-based sorting (which I assume is not your desired behavior). Could you take a screenshot of your scenario? 

Zafar Yuldashev

Dear Greg, 

 

thanks for your comment. seems i always used some prefix or suffixes, which made the proper row sorting problematic. sometimes we ignore the most obvious things and try to overcomplicate the things. now it works. thanks a lot and have a great day.