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
tony1.3965458682748613E12tony1.3965458682748613E12 

How to do nothing if logic is true

I'm trying to write a formula that looks at a date field (Termination_Date__c) and if the field already has a date then do nothing but if it is blank then enter today's date.  I assume I would do something like this:

IF(ISBLANK(Termination_Date__c),TODAY(),---but here in the FALSE return area what do I enter to do nothing if the field Termination_Date__c is not blank?---)

I'm not sure how to proceed.  Any help would be appreciated.
 
Michael Schmidt 42Michael Schmidt 42
If you want it to be blank if the Termination Date is populated then IF(ISBLANK(Termination_Date__c),TODAY(),NULL).
If you want it to hold the value in the Termination Date then IF(ISBLANK(Termination_Date__c),TODAY(),Termination_Date__c).
Ajay K DubediAjay K Dubedi
Hi Tony,
Firstly create a Date type Field 'Termination Date' and then create another field 'Updated_Date__c' formula type and then apply this formula for to fulfill your requirement-

if(ISBLANK(Termination_Date__c),TODAY(),NULL)

I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks,
Ajay Dubedi