+ Start a Discussion
RajashriRajashri 

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?

Best Answer chosen by Admin (Salesforce Developers) 
Devender MDevender M
Hi,
try this validation rule
IF(ISCHANGED(Date__c), Not(ISCHANGED(Comments__c)), false)

All Answers

mbhardwajmbhardwaj
Sorry, couldn't understand your requirement. Can you elaborate whats needed.
Rise AnalyticsRise Analytics

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.

yunicfayunicfa

maybe .. comment isnt blank . try first without isblank() .. and check if  it works !! 

Devender MDevender M
Hi,
try this validation rule
IF(ISCHANGED(Date__c), Not(ISCHANGED(Comments__c)), false)
This was selected as the best answer
Neha LundNeha Lund

Just try this...

Not(isblank(Comments__c))
&&
ISCHANGED(Date__c)