You need to sign in to do that
Don't have an account?
Rajashri
Simple Field Update (Using a formula field)
Hi,
I want to throw the error message for comments field if everytime Date field is updated
I have written the formula below but whenever comments field is not blank it is not working properly.
isblank(Comments__c)
&&
ISCHANGED(Date__c)
Can anyone help?
try this validation rule
IF(ISCHANGED(Date__c), Not(ISCHANGED(Comments__c)), false)
All Answers
Are you saying you want the rule to fire when Comments is not blank? In that case, you just need to remove "isblank(Comments__c)"
Also not sure if that is really what you are asking though.
maybe .. comment isnt blank . try first without isblank() .. and check if it works !!
try this validation rule
IF(ISCHANGED(Date__c), Not(ISCHANGED(Comments__c)), false)
Just try this...
Not(isblank(Comments__c))
&&
ISCHANGED(Date__c)