Autonumber generated only for rows in Column A that are blank

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?

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.