+ Start a Discussion
Samuel Gonsalves 8Samuel Gonsalves 8 

Formula field to display a value based on lookup field value in salesforce

Hi All,
I need to create a formula field "Branding Theme" with return type "TEXT" which will basically update a particular value based on the owner selected in opportunity. Also needed the quote number from quote to be display besides it. Have tried this
IF(TEXT( Owner.Username )='sam@gmail.com','PPAU &""&  SyncedQuote.QuoteNumber ',
   TEXT( Owner.Username )='kishor@gmail.com','PPUS &""&  SyncedQuote.QuoteNumber '
)

But this is not working . Can anyone please help me out with this?

Thanks

Regards,
Samuel
Best Answer chosen by Samuel Gonsalves 8
ManojjenaManojjena
Hi Samuel ,

try with below formula it will work .
IF( Owner.Username =='sam@gmail.com','PPAU' &" "&  SyncedQuote.QuoteNumber,IF( Owner.Username =='kishor@gmail.com','PPUS'&' '&SyncedQuote.QuoteNumber,null) )

Thanks 
Manoj

All Answers

ManojjenaManojjena
Hi Samuel ,

try with below formula it will work .
IF( Owner.Username =='sam@gmail.com','PPAU' &" "&  SyncedQuote.QuoteNumber,IF( Owner.Username =='kishor@gmail.com','PPUS'&' '&SyncedQuote.QuoteNumber,null) )

Thanks 
Manoj
This was selected as the best answer
Samuel Gonsalves 8Samuel Gonsalves 8
Thanks Manoj, it works now....