function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
WPCMSWPCMS 

ISCHANGED Formula Issues

We have a field that is blank until an opportunity goes active. When the opportunity goes active we update the Active_Name__c. This name can never change once the record is saved. I used ISCHANGED for the validation rule but if it was blank before it still prevents a save.

 

How do I set up the formula to where it looks to see if it is null first , and if it isn't then it goes to the ISCHANGED rule?

 

I tried

 

isnull(Active_Name__c)=False && ISCHANGED(Active_Name__c)

 

But this does not give me my results.

 

Any suggestions?

 

Thank you in advance.

Best Answer chosen by Admin (Salesforce Developers) 
wgrawgra

How about this one:

 

 

AND( NOT(PRIORVALUE(Active_Name__c )=""), ISCHANGED(Active_Name__c) )