Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: Formulas
Solved
Jump to Solution
592 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Solution

Accepted Solutions

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:

See Solution in Thread

3 Replies 3

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!

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