3

created workflow criteria is created and everytime edited but it's not working if priorvalue of internal status is blank or --None-- and record is not isNew() then update internal status picklist is "In-progress"

AND( 
    ISPICKVAL(PRIORVALUE( InternalStatus__c), " "), 
    OR(ISPICKVAL(PRIORVALUE( InternalStatus__c), "--None--")), 
    NOT(ISNEW()) 
)
1
  • 3
    Use ISBLANK(TEXT(PRIORVALUE(InternalStatus__c))) to detect blank
    – Raul
    Commented Feb 27, 2017 at 9:38

1 Answer 1

5

Try this.

AND( 
    ISBLANK(TEXT(PRIORVALUE(InternalStatus__c))), 
    NOT(ISNEW()) 
)
1
  • 3
    Ah i did a cross post, was few mins late. +1!
    – Raul
    Commented Feb 27, 2017 at 9:42

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .