function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
RAHMAN HASHMIRAHMAN HASHMI 

my formula is not working

If this field is null Name_the_issuer_if_different_to_client__r then i want to replace with Client_Name__r.
can you help guys

IF(ISNULL(IBC_Booking_Form__r.Name_the_issuer_if_different_to_client__r.Name),IBC_Booking_Form__r.Client_Name__r.Name,IBC_Booking_Form__r.Name_the_issuer_if_different_to_client__r.Name)
Anthony McDougaldAnthony McDougald
Good Afternoon Rahman,
Hope that your day is off to an amazing start. Is it safe to assume that both of the said fields are lookup fields? If so, I would recommend just using the API name of the fields from the object rather than picking out certain fields related to the object in relation to the object that this formula is in regards to. Looking forward to serving you and may God bless you abundantly.
Best Regards,
Anthony McDougald 
Dushyant SonwarDushyant Sonwar
Rahman ,

Also add ISBLANK in your formula field , it will work fine. 
IF( OR(
	    ISNULL(IBC_Booking_Form__r.Name_the_issuer_if_different_to_client__r.Name)
	,   ISBLANK(IBC_Booking_Form__r.Name_the_issuer_if_different_to_client__r.Name)
	),IBC_Booking_Form__r.Client_Name__r.Name , IBC_Booking_Form__r.Name_the_issuer_if_different_to_client__r.Name)