I'm working on adjusting formula field on my custom object which is related to Account.
The current formula looks like this:
Customer_Name__r.Parent.Name & " " & "(" & HYPERLINK("/" & Customer_Name__r.Parent.Id, "View Details", '_self') & ")"
It's supposed to show the name of account's parent account & clickable "View Details" link that directs to that parent.
The issue is that when there is no parent account, it will only display (View Details) with link to homepage.
I'm trying to find a way to force this formula to display "No Parent" when there is no parent account it can pull the info from.
Thank you in advance!
3 respuestas
Try this..
if( ISBLANK(Customer_Name__r.Parent.Id), "No Parent", Customer_Name__r.Parent.Name & " " & "(" & HYPERLINK("/" & Customer_Name__r.Parent.Id, "View Details", '_self') & ")" )
