You need to sign in to do that
Don't have an account?
Alesha Kuhlman
Trying to get a Validation rule to work but it is not working? Any help is appreciated.
AND(
Or(
(ISPICKVAL(StageName , "9 - Closed/Lost (0%)")),
(Ispickval(StageName, "6 - Closed/Won (100%)"))),
ISBLANK(Text( Close__c )),
or(not
($RecordType.Name = "Existing Business Renewal '17",
$RecordType.Name="Service/SOW '17",
$RecordType.Name="Recurring Revenue"))
)
Or(
(ISPICKVAL(StageName , "9 - Closed/Lost (0%)")),
(Ispickval(StageName, "6 - Closed/Won (100%)"))),
ISBLANK(Text( Close__c )),
or(not
($RecordType.Name = "Existing Business Renewal '17",
$RecordType.Name="Service/SOW '17",
$RecordType.Name="Recurring Revenue"))
)
AND(
Or(
(ISPICKVAL(StageName , "9 - Closed/Lost (0%)")),
(Ispickval(StageName, "6 - Closed/Won (100%)"))
),
ISBLANK(Text(Close__c )),
not(or
($RecordType.Name = "Existing Business Renewal '17",
$RecordType.Name="Service/SOW '17",
$RecordType.Name="Recurring Revenue"))
)
All Answers
AND(
Or(
(ISPICKVAL(StageName , "9 - Closed/Lost (0%)")),
(Ispickval(StageName, "6 - Closed/Won (100%)"))
),
ISBLANK(Text(Close__c )),
not(or
($RecordType.Name = "Existing Business Renewal '17",
$RecordType.Name="Service/SOW '17",
$RecordType.Name="Recurring Revenue"))
)