Sign Up ›

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.