
Hi Everyone
Need some help with a simple workflow validation rule.
I am trying to update the date field automatically to current date if price of a commodity is greater than 5000 dollars.
1. I have been trying to use this formula IF(Price__c > 5000, Alert_Date__c = today(), Alert_Date__c <> today())
2. However, every time I try to validate this the date field doesn't changes.
Any help is much appreciated. Thanks in advance.