I'm trying to write a formula which should populate with a value from any one of the below field references, if they are not blank (i.e. one or more could be blank, but they would all point to the same value). How can I specify the criteria to fill in a value for whichever one of this isn't blank?
CCMI_Contact_Assignment__r.Regional_Affiliation__c
Parent_Partner__r.Regional_Affiliation__c
Work_Based_Learning_Assignment__r.Regional_Affiliation__c
5 answers
Hello Nicolle, Hope that your day is off to an amazing start. Below is the solution that you're looking for. Hope this helps and may God bless you abundantly.
IF(NOT(ISBLANK(CCMI_Contact_Assignment__r.Regional_Affiliation__c)), CCMI_Contact_Assignment__r.Regional_Affiliation__c,
IF(NOT(ISBLANK(Parent_Partner__r.Regional_Affiliation__c)), Parent_Partner__r.Regional_Affiliation__c,
IF(NOT(ISBLANK(Work_Based_Learning_Assignment__r.Regional_Affiliation__c)), Work_Based_Learning_Assignment__r.Regional_Affiliation__c, null
)
)
)
Best Regards,
Anthony McDougald
