ID's for lines

[Darren_Murphy]

@Darren_Murphy

So putting all that together, 4 columns required:

1. Rollup to determine the current max order ID
2. Math column to increment that by 1
3. ITE column to determine how many zeros required for padding
4. Template column to join 2 & 3

Yes, steps 3 and 4 just do some padding (because that’s what the OP in that topic was looking for). But steps 1 & 2 provide auto-numbering.