Autonumber generated only for rows in Column A that are blank

jl.furstenberg

Hello,

I am trying to figure out a solution and would love some help.

I have Column A that contains a unique employee ID number for each employee. However, I want to include potential employees in Column A as well, and they will not have an employee ID number (i.e., Column A will be blank). I want an auto-number to generate for those potential employees.

Essentially, I only want an autonumber for rows where Column A is blank. What would be the best way to solve this?

Adam Murphy

I would add an autonumber column (RowID) which will give all rows a number (with a prefix, etc), even for employees. You can hide this column. I would then add a helper column to "replace" Column A, using a column formula such as =IF([Column A]@row = "", [RowID@row], [Column A]@row]. Hide Column A and use the new one in it's place and you will see the Employee ID from Column A if it exists, otherwise you will see the RowID. Make sense?

jl.furstenberg

Hello Adam,

Thank you for your response! This worked out great. Your help is much appreciated.