Show 2 Lookup fields as indicator - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Jonathan WolffJonathan Wolff 

Show 2 Lookup fields as indicator

Hi,
I want to build an Indicator in my Contacts. If the one Lookup field "AG_Kontakt__c" is used in the contact it should show one Indicator and when the Lookup field "AN_Kontakt__c" is used it should show the other image.
Else there shouldn't be shown anything.

Greetings
Jonathan
Best Answer chosen by Jonathan Wolff
Tom BassettTom Bassett
Sorry I free typed the formula without using the syntax checker. 

Try a , after the last icon 
 
IF(AG_Kontakt__c != "", "😀",
IF(AN_Kontakt__c != "", "😀",
""))

 

All Answers

Tom BassettTom Bassett

Hello Jonathan,

It sounds like at a high level you need a IF Formula to achieve what you need.

Ultimately you would determine if the field is != "" which basically translates to is not blank.

Your formula would be something like this

IF(AG_Kontakt__c != "", "😀",
IF(AN_Kontakt__c != "", "😀"
""))
nb: Feel free to swap out the icons for your preference you could also use Images from a Public Accessible URL.

If this helps please mark as best.
​​​​​​​

Thanks, Tom

Jonathan WolffJonathan Wolff
Hi Tom,

sadly it didn't work. It shows me the error that there is an missing ")". I dont know how to solve this problem
Tom BassettTom Bassett
Sorry I free typed the formula without using the syntax checker. 

Try a , after the last icon 
 
IF(AG_Kontakt__c != "", "😀",
IF(AN_Kontakt__c != "", "😀",
""))

 
This was selected as the best answer
Jonathan WolffJonathan Wolff
Thank you <3
Tom BassettTom Bassett
Glad I could help 🤗