Assigning Unique IDs

Akrenn12

Hello!

I am trying to develop a function for a cell to produce a unique ID only if another cell is blank. Some of our assets has predetermined IDs and some need ones assigned, which I am hoping we can automate. Any suggestions?

Paul Newcome

In that case you would need 3 columns. One that generates the default (auto-number column or formula), one that allows manual entry, and then the third would show the desired ID using an IF statement along the lines of

=IF([Manual ID]@row <> "", [Manual ID]@row, [Default ID]@row)

Paul Newcome

Are you able to provide a screenshot for reference?

Akrenn12

Screenshot 2023-03-08 101811.jpg

Sure! So, I want anything that has a blank cell in the StockID column to populate an auto-generated ID. I attached a picture of what I am thinking. @Paul Newcome

Paul Newcome

In that case you would need 3 columns. One that generates the default (auto-number column or formula), one that allows manual entry, and then the third would show the desired ID using an IF statement along the lines of

=IF([Manual ID]@row <> "", [Manual ID]@row, [Default ID]@row)

Akrenn12

Thank you! That worked perfectly.

Paul Newcome

Happy to help. 👍️

Akrenn12

@Paul Newcome I have another question along the same lines!

So, I have a fourth column that, if 'reused' is selected, it will leave the auto-generated ID cell blank in an auto-generated ID column. Is this possible? The initial setup is above, which I still need, plus this new function I am asking about.

Akrenn12

@Paul Newcome