How to restrict users typing free text in a picklist field?
I have had a look around validation rules and pick list but i'm not to sure which would be the best to use.
Our Subject field is a picklist, however users can still type free text. This is causing problems when running a report as not all data is accurate.
I would like to implement a validation rule to only allow the picklist value to be selected and no option for free text.
Could someone please help me?
A custom field which i created as a picklist appears as a drop down.
Not sure if it is because it is pre-defined field.
NOT(OR(CONTAINS( Subject ,"Call"),CONTAINS(Subject,"Email")))
You can continue adding values and replace for call and email, but the idea is that if it does not contains call or email, throw an error.
edit: Steve's will work just as well, just remember to add the commas for the and function :]
Thanks for your feedback it has been very useful.
I have just entered the following:
TEXT(Subject) <> "Supplier Visit / Call ",
TEXT(Subject) <> "IBC Visit",
TEXT(Subject) <> "Phone Call",
TEXT(Subject) <> "E-Mail")
It comes up with an error message: Error: Incorrect parameter for function 'TEXT()'. Expected Number, Date, DateTime, Picklist, received Text
Subject is a picklist. Not sure where i am going wrong i'm not the greatest with formula's could you help further?
This one should do it:
Subject <> "Supplier Visit / Call ",
Subject <> "IBC Visit",
Subject <> "Phone Call",
Subject <> "E-Mail")
Your help is much appreciated.