I am trying to figure out how to adjust my existing VR so that it will check for in-flight AND new records.
The rule below fires an error message if a Status value does not equal any of the ones listed. However, I also need this to fire on the creation of the record so that users cannot enter anything outside of those three values listed below.
Unsure of where the ISNEW element would go. Thanks in advance!
AND( ISCHANGED(Status__c), NOT(ISPICKVAL(Status__c, "Saved - Not Submitted")), NOT(ISPICKVAL(Status__c, "Ready for Type II Team Review")), NOT(ISPICKVAL(Status__c, "Winner Selected")))
#Validation Rule #Sales Cloud #Service Cloud
Hi Dominique,
You can try below error formula:
AND(
OR(ISNEW(), ISCHANGED(Status__c)),
NOT(ISPICKVAL(Status__c, "Saved - Not Submitted")),
NOT(ISPICKVAL(Status__c, "Ready for Type II Team Review")),
NOT(ISPICKVAL(Status__c, "Winner Selected"))
)
Hope it helps :D
