I have 3 text formula fields: Field 1, Field 2 and Field 3. I want to create Field 4 formula field that checks if there is value in any of those 3 fields and give the value to Field 4.
I have tried:
IF ( NOT(ISBLANK (Field_1__c)), Field_1__c, NULL) - but the formula is too big to execute.
BLANKVALUE (Field_1__c, NULL) - but I want to be able to check all 3 and the populate Field 4 with the value
Thanks a lot.