• Tag Lee
  • 0 Points
  • Member since 2018

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
  • 0
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