AnsweredAssumed Answered

Help with Formula

Question asked by Sunny1 on Nov 3, 2010
Latest reply on Nov 3, 2010 by Sunny1


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