I have five url fields on a custom object, an email template is created to send out the email to users with the custom object(record) content. My requirement is, I should display the url links in the email template, if there is one or more url fields have data in the record. Hence I have to create a formula field of text data type. Tried doing it, but this isn't displaying the link value and if the record has more than one field value, it doesn't work.
IF(NOT(ISBLANK(link_1__c)),link_1__c, IF(NOT(ISBLANK(link_2__c)),link_2__c, IF(NOT(ISBLANK(link_3__c)),link_3__c, IF(NOT(ISBLANK(link_4__c)),link_4__c, IF(NOT(ISBLANK(link_5__c)),link_5__c, null ) ) ) ) )