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
Deanna Aaron 4Deanna Aaron 4 

Formula help: If field is not blank, pull in this value

Hi. I'm trying to create a formula field that says: 
If the authorization field is not blank (there is a value in this field) -- then, reference this record and make it a hyperlink. The hyperlink part works, but I'm having issues with the IF"NOT(ISBLANK) part..

This is what I'm working with now, but I'm getting an error that I have an extra comma.
This works:

(HYPERLINK("/" & ffasp__PaymentAuthorisation__c, "Payment"))

...But I only want this to populate if the "Auth" field IS NOT blank.

I tried this, but got an error:

NOT(ISBLANK(PaymentAuth__c),
HYPERLINK("/" & ffasp__PaymentAuthorisation__c, "Payment"))

Thank you for your help.

Best Answer chosen by Deanna Aaron 4
AnkaiahAnkaiah (Salesforce Developers) 
Hi Deanna,

try with below formula 
If(NOT(ISBLANK(PaymentAuth__c),
HYPERLINK("/" & ffasp__PaymentAuthorisation__c, "Payment"),'')

If this helps, please mark it as best answer.

Thanks,
Ankaiah