Jira Structure Formula

[Ryan Lagola]

I'm very new to structure and I'm trying to add the right formula to a structure column to display certain text when my issue meets certain criteria.  The exact thing I'm trying to do is display the text "Refine Me" if my issue type is "Story" and the status of the issue is in "Backlog" or "Make Ready".  What's the appropriate syntax that I can use for this?  I think I'm getting my JQL and EXPR confused and the error message isn't very helpful.  Thanks!  

if (type = 'Story' and status in ('Backlog', 'Make Ready')): 'RefineMe';

[Valerie Knapp · Accepted solution]

Hi @Ryan Lagola , thanks for your question. 

Have you checked out the documentation for this -

https://help.tempo.io/structure/latest/adding-a-formula-column 

https://help.tempo.io/structure/latest/advanced-expr 

If you're still stuck, you can also open a ticket to the vendor, who, in my experience, are super helpful - https://marketplace.atlassian.com/apps/34717/structure-by-tempo-jira-portfolio-management-ppm 

Hope this helps.

Best wishes