I’m looking for a formula that can help me add the numbers 1-6 to records, looping.
So:
Row 1 - 1
Row 2 - 2
Row 3 - 3
Row 4 - 4
Row 5 - 5
Row 6 - 6
Row 7 - 1
Row 8 - 2
I’ve thought about using the autonumber field and then trying to extract the numbe...