Generate row IDs with new rows on top
I have a sheet in which rows are added from a Smartsheet form. In the form, I used the feature that new rows are added on the top of the sheet instead of the bottom. So every time there is a new entry the first row is the last entry. In this scenario, is it possible to use the "auto-number column type" to give an ID to each row that gives the last number to the first row?
This would mean that if there are 50 entries, row 1 would have assigned an ID #50 and row 50 would have assigned an ID #1. And if we add one more entry, row 1 would be #51, row 2 would be #50 and row 51 would be #1, and so on...
Thank you so much!!!!