I am very new to creating formulas in a SP column, so hopefully I explain it accurately.
I have a requirement to have a custom number auto-generate to display (ACR Number) PF-IS-VH-17-000. 1st field cat.(2 options), 2nd = business unit, 3rd = location (3options)and then YY-sequential number (3 digits).
This is my formula:
=IF(Category="Project File","PF-IS-"&TEXT(Created,"yy")&CONCATENATE("-",REPT("0",MAX(0,3-LEN(ID))),ID),IF(Category="Change Control","CC-IS-"&TEXT(Created,"yy")&CONCATENATE("-",REPT("0",MAX(0,3-LEN(ID))),ID)))
My problem is I do not know how to get the 3rd field in there, the associated column in a CHOICE column with 3 locations to choose from. Please and thank you.