+ Start a Discussion

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) 

How about this one:



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