+ Start a Discussion
SeannoSeanno 

Validation Rule for Task

I'm trying to make a validation rule so my sales floor can't enter anything but items from a picklist in the subject line of a task.  I have the formula figured out, but can't seem to add a line for the emails.  By default the subject fills in with "Email: subject wording of the email".  Is there a way to put in "Email: (wildcard value)" in my formula" so that anything starting with the subect of "Email:" would be valid, and anything following the words "Email:" would be wildcard?  Here's what I got.

 

NOT(Subject = "Intro Call"
||Subject = "Detail Call"
||Subject = "Re-close Call"
||Subject = "Maint Call"
||Subject = "Maintenance Call"
||Subject = "Not Available"
||Subject = "Available - No Order"
||Subject = "Closed Order" 
||Subject = "Call Tag Request Sent"
||Subject = "Email: *")

 

Need help on the last line.  Thanks.

 

Best Answer chosen by Admin (Salesforce Developers) 
symantecAPsymantecAP

Hi 

You can use Contains for last value.

All Answers

symantecAPsymantecAP

Hi 

You can use Contains for last value.

This was selected as the best answer
SeannoSeanno

Not sure how that would look.   I looked at the "Contains" formula, and it says it returns one value if true and another if false.

SeannoSeanno

Cannot find the subject field id to work in the formula "Contains".

SeannoSeanno

Nevermind, I figured it out.  Thanks.