You need to sign in to do that
Don't have an account?
SFDC palace
Validation Rule
Hi,
Trying to set up a Validation Rule on Leads, and cannot get this one to work, can anyone see an error. If bolean = True, and Sales Type = Field Sale, then error if Sales Visit date = NULL, for Record type.
Any help would be really appreciated.
Thank you
AND (
(Convert_this_Lead__c = TRUE),
ISPICKVALUE(Sale_Type__c ,"Field Sale"),
ISNULL(Initial_Sales_Visit_Date__c ),
$RecordType.Name = "EUR:Pickfords Business Moving")
(Convert_this_Lead__c = TRUE),
ISPICKVALUE(Sale_Type__c ,"Field Sale"),
ISNULL(Initial_Sales_Visit_Date__c ),
$RecordType.Name = "EUR:Pickfords Business Moving")
Hard to tell with the smilies, but try removing the "=TRUE"
Sometimes a field is, in itself, either true or false and doesn't need to be checked - it's redundant.
Thanks for you help, above is the correct formula, Interesting that you do not have to give a value for a bolean field. I could not find this in any help screen, a source at SFDC even said to use 1 or 0.
any help woudl be appreciated, not sure why this does not work...