function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sfdc freshersfdc fresher 

validation rule in pick lists

Hi all,

I have one picklist filed  "Priority " with values low, medium, high, urgent.
when the record is created that  Priority should be low .Inorder to ensure that I need to validate that by using validation rule whether the user created the record with the Low value only ,it should not be null /medium/high/urgent.
Could anyone please give me the logic for this?
 
Alain CabonAlain Cabon
Hi,

This condition for a validation rule should be sufficient. 

TEXT(Priority__c) != "Low" && ISNEW()

 
Sagar PatilSagar Patil
Try this,
 
AND( 
    ISNEW(), 
    Text(Priority) <> "Low" 
)

Above formula will not allow to save the record without selecting the Low value from priority picklist while the record creation.

Kindly use API name of field and values.

If it solves your problem then please mark this answer as best answer.

Regards,
Sagar