9 Replies Latest reply: Jan 17, 2013 5:15 PM by Ellen Blackwell RSS

    WildMatch expression in Text Object, wrong syntax or not possible?

    Ellen Blackwell

       

      Hello,

       

           IF(WildMatch([FieldA], '*Exit*'),

                THEN this expression to create the field to use: ['Text[FieldValue]Text'],

                     ELSE this expression to create the field to use: ['Text[FieldValue-1]Text']

       

      The expression I'm using:

       

       

      If

      (wildmatch(PRJ_Current, '*Exit*'), 'PRJ_P'&[PRJ_Current Phase ID]&' Phase Exit Date Target', 'PRJ_P'&([PRJ_Current Phase ID]-1)&' Phase Entry Date Target')

       

      Thanks in advance!

      Ellen