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
MacLeanMacLean 

Formula: If Empty

I have the following formula:

 

TEXT(YEAR(ODS_Complete_Date__c))+"/"
+TEXT(MONTH(ODS_Complete_Date__c))+"/"
+TEXT(DAY(ODS_Complete_Date__c))

 

How can I wrap that so that if Completion _Date is empty dont display anything?  Otherwise is displays "//"

 

Thanks, Mac

 

hemantgarghemantgarg

You can try isBlank() or isNull() function.