Don't have an account?
Search for an answer or ask a question of the zone or Customer Support.
You need to sign in to do that
Sign in to start searching questions
Signup for a Developer Edition
Sign in to start a discussion
AND( TEXT(Status) = "Completed", CONTAINS(LOWER(Subject), "tbd") )
AND( Subject <> "TBD", ISPICKVAL ( Status , "Closed") )
All Answers
So the final validation rule is actually:
AND(
CONTAINS( subject , "TBD") ,
ISPICKVAL( Status, "Completed")
)