If then condition

[zwyne]

Hello everyone,

How can I write the statement below to produce one Flag instead of two like I did?

if(Match([Issue Priority],'Major')and Match([Issue Status],'On Track'),'MajFlagTrc' ,
        if(Match([Issue Priority],'Major')and Match([Issue Status],'Pipeline') and DaysFlag='30 Days','MajFlagPipe'

I am talking about the 'MajFlagTrc'  and 'MajFlagPipe'

Thanks

[sunny_talwar]

One flag? Which one of the two you want to produce?

[zwyne · Accepted solution]

Something like this

if(Match([Issue Priority],'Major'),
      if(Match([Issue Status],'On Track') or (Match([Issue Status],'Pipeline') and DaysFlag='30 Days'),'MajFlag',

I have tried it but it's not working as expected.

[rwunderlich]

if(Match([Issue Priority],'Major')and Match([Issue Status],'On Track'),'MajFlagTrc' ,
        if(Match([Issue Priority],'Major')and Match([Issue Status],'Pipeline') and DaysFlag='30 Days','MajFlagPipe'

)) as Flag

You just need to close out the if() statements and add an "as" to assign to  a field.

[zwyne]

It turned out this expression is correct

if(Match([Issue Priority],'Major'),
      if(Match([Issue Status],'On Track') or (Match([Issue Status],'Pipeline') and DaysFlag='30 Days'),'MajFlag'

[sunny_talwar]

Even without the ending parenthesis as suggested by @rwunderlich

[zwyne]

Actually my statement is incorrect, I am talking about  this one

if(Match([Issue Priority],'Major'),
       if(Match([Issue Status],'On Track') or (Match([Issue Status],'Pipeline') and DaysFlag='30 Days'),'MajorFlag'

The problem is   the or operator.