New to Smartsheets Formula for Output Referenced on a Different Sheet
I am creating essentially a unique ID for each user who completes the form.
I am trying to output a Unique ID in a column which needs
(1) Auto Number (I figured that out) and (2) concatenate with another row that has various specific prefixes on the same worksheet depending on the Organization filling out the form.
For example if Continental Societies, Inc. fills out the form I want create a Unique ID by combining the Abbreviated Org Name with the Row ID.
I'm just not sure how and which formula to use either INDEX or IF statement to look through the list of Full Org Names to select the correct Abbreviated Org. Name.
Thanks for the support,
Help Article Resources
Check out the Formula Handbook template!