How to give condition in Formula in Structure for Assignee

Sanjivani Wayal

Hi,

I am trying to retrieve Value by giving condition for Assignee column in Structure but it directly goes in Else , The Asignee's are part of Groups -

 

with FORMAT_CAPTION(color, caption) = (
""":panel[$Caption]{backgroundColor=$color color=white}"""
If Assignee = 'membersOf("ABC_CustomerEdit")' :
FORMAT_CAPTION('Green', '**ABC**')
Else :
FORMAT_CAPTION('Green', '**XYZ**')

It directly goes in Else condition and prints XYZ , wanted to know What is wrong with above If condition

Evgenii

Hi, @Sanjivani Wayal 

Try this, slightly refactored formula. I used JQL to check IF condition

with FORMAT_CAPTION(color, caption) = (""":panel[$Caption]{backgroundColor=$color color=white}"""):
IF JQL{assignee in membersOf("ABC_CustomerEdit")} : FORMAT_CAPTION('Green', '**ABC**')
ELSE : FORMAT_CAPTION('Green', '**XYZ**')