Skip to main content
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 respuestas
  1. 21 ene 2022, 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