You need to sign in to do that
Don't have an account?

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.
How about this one:
AND( NOT(PRIORVALUE(Active_Name__c )=""), ISCHANGED(Active_Name__c) )