I’m using Row to create a Unique ID combined with a letter. Unfortunately if you try to sort then it sorts by the first digit, eg A1, A10, A100, A2, A20, A200.
How do I make the formula so that the row ID will always show 3 figures, eg A001, A002, A010, A020, A100, A200?
Current formula is:
Concatenate(thisRow.[Question section],RowId(thisRow))