Adding subsequent row ID numbers to prefix if cell is not blank
Hi all, I'm struggling to create a row ID field where it will populate an ID number ID_RC_1 and so on if the Employee Name cell is not blank. If it's blank then it will populate "-". Is there a way to create sequential numbering to be included after the "ID_RC" prefix?
Looking for : ID_RC_1, ID_RC_2... is name cell is not blank.
Avoiding the auto number system as it populate IDs for rows that are irrelevant.
Thanks in advance for the help!
Help Article Resources
Check out the Formula Handbook template!