Skip to main content
Topics#FormulasDeveloper Forums User (Inactive)의 질문
Developer Forums User (Inactive) (Salesforce Developer Forums) 님이 #Formulas에 질문했습니다
2022년 1월 20일 오후 10:11

Formula Field - Account Owners

I need to create a custom formula field on the account that evaluates the owner ID of an account and then fills a field out with a text value (a name).

Here is the breakdown I need.

Owner ID 1 = Name 1

Owner ID 2 & 3 = Name 2

Owner ID 3 & 4 = Name 3

Any ideas?
답변 7개
  1. Sai Praveen Kumar Kakkirala (Salesforce)
    2022년 1월 21일 오전 3:46
    Hi Brett,

    Thanks for confirming. Can you try thr below formula. Replace the ownerids as per your requirement.

     

    if( OwnerId ='0055j000000XLmV', 'sample1' , if( OR(OwnerId ='0055j000000XERR',OwnerId ='0055j000000XERT'),'SAMPLE2', IF(OwnerId='0055j000000Xfs4', 'SAMPLE3','')
    )
    )

    If this solution helps, Please mark it as best answer.

    Thanks,

     
답변을 작성하세요...
0/9000