Vendor management and ID #
I would like to assign unique vendor IDs in a database according to vendor type (independent column) and sequential numbering. Screenshot of what I am trying to produce below.
I have found that the Auto Number column type only accepts a fixed prefix and thus cannot populate different prefixes based on Vendor Type along with its sequential numbering.
What is the best way to do this?
Help Article Resources
Check out the Formula Handbook template!