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
Renee KroonRenee Kroon 

Date field filled AND pickval is not

Hello,

I need some help for the following formula.

If date field (DATE_c) is filled AND Picklist value (Picklist_c) is NOT equal to "Inactive". 

If so, than picklistvalue must be set to Inactive.

Thanks for your help! :-)
Best Answer chosen by Renee Kroon
CharuDuttCharuDutt
Hii Renee Kroon
Try Below Validation Rule 
AND (
NOT( ISPICKVAL( Picklist_Field__c , 'Inactive') ) ,
NOT(ISBLANK( Date_Field__c ))
)
Please Mark it As Best Answer If It Helps
Thank You!