You need to sign in to do that
Don't have an account?
Samuel 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
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
try with below formula it will work .
Thanks
Manoj
All Answers
try with below formula it will work .
Thanks
Manoj