Hi all,

I have one picklist field named DEPT_Function__c. and the values for the field are TTL,SSC,ESS, and LSS 

I have already created an Auto number field named Audit_Number__c

I would like to update the intial auto number criteria based on the slection of the picklist value - Ex - TTL-{YY}-{000} or SSC-{YY}-{000}

Please suggest a formula. I tried a few formulas with no luck :( 

Thanks in Advance