Trying to set up a validation rule for new records. I want to make sure picklist field is set to 'New'. Here is my validation rule:

AND( ISNEW() ,NOT( ISPICKVAL( Status__c , "New") ))

Unfortunately, I'm not able to create a record with any status value even if I set it as New. Any suggestions?

  • Do you have any triggers on this object? Are you certain you're setting the right field? – Adrian Larson Aug 8 '17 at 17:26
  • none of that is on object – user569925 Aug 8 '17 at 17:54

Try this , it will work I am sure, if it's not working then check if there is any trigger or validation for that specific object.

 AND( ISNEW() ,   NOT(ISPICKVAL( Status__c , 'New')) )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.