Skip to main content The new Salesforce certifications experience is live! Visit Trailhead Academy to explore your new certifications homepage.
Topics#Data ManagementSamita Das's Question
Samita Das (XYZ) asked in #Data Management
May 8, 2018, 6:54 AM

Validation rule on picklist value to be increased not decreased

Hi,

 

I have a custom field "Severity" on CASE object . its a picklist and its value are 1,2,3,4,5 . So I want to write a validation rule for it i.e. If the current severity is 2 it can only be changed to 3 or 4 0r 5 and not to 1. The value can be increased but not decreased during an update operation.

 

I tried writing this but no luck. Please let me know:

 

PRIORVALUE(Severity__c) > Severity__c
6 answers
Loading
  1. Pradeep Konakanchi (PwC India)
    May 8, 2018, 8:46 AM
    Hi Samita,

     

    You missed the PRIORVALUE part in your latest rule.

     

    Try this and it should work.

    AND( 
    ISCHANGED(Severity__c), 
    VALUE(Text(PRIORVALUE(Severity__c))) > VALUE(Text(Severity__c) ) 
    )

     

    Regards,

     

    Pradeep.
Write an answer...
0/9000