Skip to main content
Topics#FormulasRakesh Mallikarjun's Question
Rakesh Mallikarjun (Bit Order Technologies) asked in #Formulas
Jan 30, 2021, 1:18 PM

Hi All, can any one please tell How can i achieve this in validation rule

fileds :

Status

partsorderlines

I can update the status from Draft to Open only if there are parts order lines. If no lines are associated with should get a validation error saying “this action can’t be performed”
2 answers
  1. Swetha Maddali (Salesforce)
    Jan 30, 2021, 1:54 PM
    HI Rakesh,

    Try below validation rule

    AND (
    ISCHANGED (Status__c),
    ISPICKVAL( PRIORVALUE (Status__c), 'Draft'),
    (ISBLANK(partsorderlines__c))
    )

    Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you
Write an answer...
0/9000