Assigning Unique IDs
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?
Best Answer
-
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)
Answers
-
Are you able to provide a screenshot for reference?
-
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
-
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)
-
Thank you! That worked perfectly.
-
Happy to help. 👍️
-
@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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!