Help with Formula
I need to have a field for an ID number do the following:
The ID number needs to consist of the Category (MS, BHS, P, etc), the Grade Level (01, 02, etc) and then a Next Serial Value.The Category and Grade level are fields and are set up with value lists.
How do I do this? I tried writing a calculated value in Project ID field but not sure the proper way.
Thank you in advance