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 · Accepted solution]

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**')

[Sanjivani Wayal]

Hi @Evgenii 

It worked Thank you so much...