function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
EtauEtau 

Help with validation rule

Hi - I am trying to write a validation rule where an error will come up if the start date is less than today, but the stage cannot be credit memo issued:

 

AND(Start_Date__c <  Today(), ISPICKVAL(NOT( Opportunity.StageName, "Credit Memo Issued"))

 

Any thoughts on what is wrong with my formula?

 

Thanks

CLKCLK

 

IF(ISPICKVAL(Opportunity.StageName, "Credit Memo Issued"),false,if(Start_Date__c < Today(),true,false))

this will work.
EtauEtau

Thanks so much that worked.  Do you know how I could exclude a record type as well?
CLKCLK

As per i know,We can't put validation on Record Type.

Because page layout is created on basis of record type only.

it's already get assigned when user select it for new record. And afterward user can't change it.