Need to add sequential, looping numbers to a series of records

Question

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 number 1-6 from that, but I’m genuinely at a loss.

ScottWorld · Accepted Answer

Welcome to the community, @Fumiko_Shinkawa!

Keep your autonumber field, and then create a new formula field with this formula:

IF(

MOD({Your Autonumber Field},6)=0,6,

MOD({Your Autonumber Field},6)

)

There might even be a more compact way to write that formula, but that’s just what I came up with off the top of my head.

This is perfect!!

Thank you so much!

Fumiko_Shinkawa · Answer

Welcome to the community, @Fumiko_Shinkawa!

Keep your autonumber field, and then create a new formula field with this formula:

IF(

MOD({Your Autonumber Field},6)=0,6,

MOD({Your Autonumber Field},6)

)

There might even be a more compact way to write that formula, but that’s just what I came up with off the top of my head.

This is perfect!!

Thank you so much!

Sign up