​In the old version of condition doesn’t exist "Contain" function, also [Choice Column] == "value" doesn’t work. The "IndexOf" function can help to solve this issue.


​Function formula: IndexOf([Choice Column], "value") != -1


There is a Status column in Task list, that is default Choice Column.

We want the condition trigger a product, when the status is "Not Started".

so the formula is: IndexOf([Status],"Not Started")!= -1

Function IndexOf:

Integer IndexOf(Text s1, Text s2)

Checks for the presence of string s2 insideof string s1. If string s1 does not contain string s2, it will return -1.

Applies for: SharePoint 2013, SharePoint 2010, SharePoint 2007

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>