Skip to main content

Hi

    can we get opportunity owner name in formula field .

case( Owner.Username ,"Ragul",'A', "Maran",'B',"Bhavani",'C',"Alia",'D',null).i got no error but in report came out 'null'.exactly my requirement is, need to  assign  A or B or C  for each opportunity owner .

2 respuestas
  1. 8 dic 2021, 9:13

    Hi,

    These don't look like a valid usernames, usernames should be email format.

    you are testing FirstName or LastName, so your formula is returning null. try this instead

    case( Owner.FirstName ,"Ragul",'A', "Maran",'B',"Bhavani",'C',"Alia",'D',null)
0/9000