I feel like this should be simple, but for some reason I'm not getting it right. I have a picklist value ("Launched") that I want to be able to be "selected" only by a workflow rule. If a user tries to update it to that value, I want to return an error.
I've set a workflow rule that updates the picklist to Launched when the "Launch Date" is selected. All that works fine.
However, I am stuck on how to create a proper validation rule that will restrict the user from selecting that particular value (while not restricting the workflow rule from firing).
Am I doing this backwards?
To be clear, I do not want to Launch Date field updated by way of selecting "Launched" from the picklist. The validation rule does (and should) only work by selecting the Launch Date which then updates the picklist to Launched.
Thanks
4 answers
Hello Brian, How about setting up a validation rule to prevent the picklist value from getting changed to "Launched" if the the Launch Date is blank.
AND(
ISBLANK(Launch_Date__c),
TEXT(PicklistField__c) = "Launched"
)
