Adding row numbers to sorted data

[WonderHog]

Is there an easy (or complicated) way to add row numbers to a sorted data table?

[Dynamomo · Accepted solution]

@WonderHog

Use the RecordID tool to add an ID to each record.

[vmiller]

What if you want the row ID to be sorted by date? (1 = wk. 1 2019, 2=wk 2 2019...... 55 = wk. 3 2020)

[Dynamomo]

@vmiller 

It might be easier if I saw some data but if you have a field containing the week and year, you could sort by this first and then add a rowid once the data is sorted.