Auto number with specific values
Hi
I'm a beginner in Smartsheet and I want to move every 5th row entry into another sheet
For this, I've tried adding a "help" column to number all of the entries, but I need this to be generated automatically every time someone enters data on a row
Is there a way to set the autonumber column property with limited values?
Best Answers

One approach is to use an autonumber column along with: a helper column, the MOD() function, workflow automation.
If autonumber starts with "1", then every 5th row that is created will contain a number that is divisible by "5". A helper column can "monitor" this. The helper column can be the trigger that causes the row to be moved.
Below is a mockup of how this would be set up.
Here's the formula for the helper column.
=IF(MOD([Auto Number Column]@row,5)=0, 1, "")
The autonumber will allow you to automate the value in QA Tracker as well.
QA Tracker =
IF(MOD([Auto Number Column]@row,5)=0, 5, MOD([Auto Number Column]@row,5))

IF your Part Number is already your autonumber column, then your function for the helper column would be,
=IF( MOD( VALUE( SUBSTITUTE([Part Number]@row, "CFVDH",""))6,5)= 0, 1, "")
The formula uses
 SUBSTITUTE() to replace "CFVDH" with a blank;
 VALUE() converts the remaining characters into a number;
 Subtract 6 from that;
 MOD() checks to see if the resulting number is divisible by 5.
IF() it is divisible by 5, then places a 1 into the cell; otherwise, leave it blank.
Answers

Hi @Aldo Perez
I hope you're well and safe!
Interesting!
How many rows can there be in total in the sheet?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Hi @Aldo Perez
Hope you are fine, please check the following post it will help you Work Breakdown Structure (WBS)  Column Formula Configuration
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

One approach is to use an autonumber column along with: a helper column, the MOD() function, workflow automation.
If autonumber starts with "1", then every 5th row that is created will contain a number that is divisible by "5". A helper column can "monitor" this. The helper column can be the trigger that causes the row to be moved.
Below is a mockup of how this would be set up.
Here's the formula for the helper column.
=IF(MOD([Auto Number Column]@row,5)=0, 1, "")
The autonumber will allow you to automate the value in QA Tracker as well.
QA Tracker =
IF(MOD([Auto Number Column]@row,5)=0, 5, MOD([Auto Number Column]@row,5))

IF your Part Number is already your autonumber column, then your function for the helper column would be,
=IF( MOD( VALUE( SUBSTITUTE([Part Number]@row, "CFVDH",""))6,5)= 0, 1, "")
The formula uses
 SUBSTITUTE() to replace "CFVDH" with a blank;
 VALUE() converts the remaining characters into a number;
 Subtract 6 from that;
 MOD() checks to see if the resulting number is divisible by 5.
IF() it is divisible by 5, then places a 1 into the cell; otherwise, leave it blank.

There can be thousands of rows in the sheet

Thank you both @Bassam Khalil and @Toufong Vang
@Toufong Vang that formula does the trick in this case, thanks!
