How can I have a table increase the number in the Sequence Field record each time a record is added.
The GMP part is from Custom Formatting.
I have tried Offset, Index, Row, and Rows.
I have a number of these tables set up for different job discriptions. I have the first one that actually increases the Sequence number the way I want, but I can not get it to work on others. I have copied the formula, the format, and made sure the table ranges are setup the same. The one that works is base on the cell above =+A5+1, then =+A6+1. When I get to the end of the table and tab to add another record that above formula is automatically added to the next record. Can't get it to work on the rest!
Sequence # GMP's - Good Manufacturing Practices
GMP 1 Caps on lines. No product contact surface can be left open.
GMP 2 Gasket changes are basic to every process and packaging
GMP 3 Clean floors, walls, ceiling, drains, pipes, overhead lines, job.
GMP 4 Housekeeping: do not not by something; pick it up.
GMP 5 Doors closed
GMP 6 Hair and beard nets are required in all processing areas.
GMP 7 No stock on floor to include platforms
GMP 8 Proper place for junk cardboard
GMP 9 How to properly clean up spills in the machine
GMP 10 Uniforms - clean, proper
The solution I found:
ROW(Table_Day_4_UF_Production[#This Row])-($A$28+1)
Bookmarks