Solved

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

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.

Best answer by ScottWorld

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. :slightly_smiling_face:

Did this topic help you find an answer to your question?

+20

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. :slightly_smiling_face:

ScottWorld wrote:

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. :slightly_smiling_face:

This is perfect!!
Thank you so much!

+20

Fumiko_Shinkawa wrote:

This is perfect!!
Thank you so much!

You’re welcome! Glad I could help! :slightly_smiling_face:

3 replies