Increasing number when meets same value autonumber, possible formula

Cybsss

Hi i badly need help! Is there any possible formula to achieve the output in SERIAL NUMBER column? By the way it is manually encoded. Thank you

che.rabajante

Hello @Cybsss

To be able to achieve the desired SN format:

• Add an Auto-Number Column (System Column): Create an Auto-Number Column (RowID). This column will automatically generate a unique number for each row, which we’ll use in calculations.

• Add Helper Columns:
  Helper Count: This column will provide a sequential count for each Sub Category Code as it appears in the rows. Use the following formula:

Helper Zeros: To achieve a three-digit format (e.g., "001"), add a column named Helper Zeros with the following formula. This formula will add leading zeros based on the Helper Count value:

• Generate the Serial Number: In the Serial Number column, combine Helper Zeros and Helper Count to create a formatted serial number:

I hope this solution works for you.🙂

Che

che.rabajante

Hello @Cybsss

To be able to achieve the desired SN format:

• Add an Auto-Number Column (System Column): Create an Auto-Number Column (RowID). This column will automatically generate a unique number for each row, which we’ll use in calculations.

• Add Helper Columns:
  Helper Count: This column will provide a sequential count for each Sub Category Code as it appears in the rows. Use the following formula:

Helper Zeros: To achieve a three-digit format (e.g., "001"), add a column named Helper Zeros with the following formula. This formula will add leading zeros based on the Helper Count value:

• Generate the Serial Number: In the Serial Number column, combine Helper Zeros and Helper Count to create a formatted serial number:

I hope this solution works for you.🙂

Che

Cybsss

Hi @che.rabajante thanks a lot, it worked! :D