+ Start a Discussion
Neil Hatch 9Neil Hatch 9 

Field validation rule -

Hi,
I had a simple field validation rule that required a comment when a particular status was set (this would normally be when my auto logic was in progress). I've now had to change the validation so that when a new item is added the status can be manually set, and require a comment.

This is the rule I have but it raises an alert all the time preventing the new recorded from being saved. Any ideas?
 

Thanks!

AND( 
ISPICKVAL(Status__c , 'Authorised'), 
AND 
(NOT(ISCHANGED( ITK_Comments__c ))) 
|| 
ISBLANK(ITK_Comments__c) 
|| 
ISNEW() 
)


 
Best Answer chosen by Neil Hatch 9
Shaik Naga janiShaik Naga jani
Hi Neil, 
use NOT(ISNEW()) it will not fire while inserting the record, when you are trying to update the record it will fire.
try below sample formula and modify as per your requirement.
AND( 
NOT(ISNEW()),
ISPICKVAL(Status__c , 'Authorised'), 
ISCHANGED( ITK_Comments__c )
)

Kindly mark this as solved if the reply was helpful.
Thanks
Shaik