You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Once I create a formula to display a standard field, it seems i am not able to retain the display icons for them. For e.g. if i were to create a standard column "Status" I can see Open/In Progress/Done etc in their native icons or display style. But if i put them in a formula and still reference the same field, it displays plain text. Is there a way for the structure to display it the same way as the native field?
Status Column vs If(issueType = "Task"; Status;if(issueType = "Story";""))
Great question, thanks! Currently, a formula column would display only a text or a number or a date. That is because once you start using a Jira value (the Status, in your case), it becomes a text.
There's an open feature request to let Formula column display some HTML or a markup, in order to provide more colorful display of the value. Your request to display the status as an icon is similar -- I will add more details to that feature request.
Watch out for new releases of Structure and thanks for using our product!
Hi Igor, I have the same question, but your answer seems outdated, since formulars are able to display markup now.
But how can I reference the native icons (or better to say the correct styles)?
I can output markup but this will end up in emulating the original styles inside an if clause.
Is there an easier way to accomplish this?
Hello @reimer_prochnow ,
David from ALM Works here. Welcome to the Community!
As far as I am aware, it is not possible to reference the native format. Emulating the original style is the only way to accomplish the goal.
Using a Local Variable, we can make the set up of the IF Conditional statement much easier though:
With FORMAT_STATUS (bordercolor,bgcolor,color,value) =
IF STATUS = "OPEN":
ELSE IF STATUS = "TO DO":
The Local Variable "With FORMAT_STATUS..." defines the general format you want to use and then for each of the IF conditional statements, you just need to enter the colors for border, background and text.
Please let me know if this helps. I look forward to your feedback.