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!

Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives