topic Re: If then condition in Water Cooler

If then condition

zwyne — Mon, 17 Dec 2018 17:57:42 GMT

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

Re: If then condition

sunny_talwar — Mon, 17 Dec 2018 18:14:46 GMT

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

Re: If then condition

zwyne — Mon, 17 Dec 2018 18:25:15 GMT

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.

Re: If then condition

rwunderlich — Mon, 17 Dec 2018 18:25:38 GMT

)) as Flag

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

Re: If then condition

zwyne — Mon, 17 Dec 2018 18:46:04 GMT

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'

Re: If then condition

sunny_talwar — Mon, 17 Dec 2018 18:54:07 GMT

Even without the ending parenthesis as suggested by @rwunderlich

Re: If then condition

zwyne — Mon, 17 Dec 2018 19:12:09 GMT

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.