I am trying to create a workflow that notifies certain users that a multi valued pick list has been updated with select values. I only want this notification to go to the user when it goes from not included to included, not every time it is saved.
For example, the options are 1,2,3,4 for a multi value list. I want the user to be notified when the opportunity includes 1 or 2, regardless of the other values. Meaning there are quite a few combinations that could happen.
My workflow has 2 steps :
- IF 'field' (before change) does not include '1' AND
- 'field' equals to '1'
the same for pick #2.
However, this only works if '1' or '2' is picked on its own, not as a combination. I would need a "contains" option on the workflow to include this.
Any ideas on how I can get this done?