I am looking to create a formula where the autonumber resets based on the category code selected.
- Each product has an Item Number which is created using autonumber.
- I used another tab to create category codes for the prefix of the floor plan ID
- I create a formula that adds the prefx and item number to create Floor Plan ID
The autonumber cannot be reset contingent on the category code. The autonumber is unique to each row created.
I would like to have a way to be able to create codes that have the number after the prefix under Floor Plan ID show an autonumber based on the amount of items under that category.
it would be AC-1 opposed to AC-2 ( because there is only 1 item with the category code AC so far)
Any help would be appreciated!