Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Highlighting few cells in Structure

Hello there,

I have a use case where we need to display count of stories in the project and highlight stories that are in cancelled status. Count of stories is achieved using a formula column with field type as "Number" and sum over subitems is enabled.

But highlighting Cancelled stories is were I'm facing issue. I'm able to highlight cancelled stories and count stories using the below formula.

Formula: 

If(issuetype = "story" and status = "Cancelled", "{panel:bgColor=#FFFF00}1{panel}"), issuetype = "story" and status != "Cancelled", 1)

Highlight works only if the column type is set as "Wiki Markup" but the sum over subitems fails in this case. If I set the column type as "Number", sum over subitems is working but highlight fails.

We can achieve this if we are highlighting the stories in a different formula column which is my last resort. But can these both be achieved in a single column?

Thanks,

Poojaa

1 answer

1 accepted

Hi Poojaa,

Phil here, from ALM Works (makers of Structure), I see we meet again on a formula conundrum. There is a middle ground option here, probably what you're looking for.

We can create a variable that we reference in this formula, that itself is another formula. You'd write your formula as normal, referencing this variable (not yet defined). When you get prompted for the variable definition, you scroll down the list of options to formula and a new editor will open in the same window and you can write a the other formula there. This gives you the benefit of two formula columns, without having to keep track of both!

Also, might be worth noting, you can create a separate column, reference it in a formula column, and then delete the first column. Structure copies by value here, so updates to that first column don't propagate (which means you'd need to re-reference if you do update the column), but in this case it also means you don't need to keep helper columns around after they've served their purpose.

Hope that helps!

Phil Heijkoop

Lead Solutions Engineer

ALM Works

Thanks again Phil!

I tried the first approach - defining a formula within formula. In this approach, cells were highlighted but during sum over subitems, highlighted cells were ignored i.e., if there are 10 stories out of which 2 are cancelled (highlighted) the sum shows total count as 8 ignoring highlighted cells. I guess it's because they are in wiki format they got ignored.

But I was able to tweak the formula to include summation within formula instead of using "sum over subitems" option. This way I was able to get the sum as well as highlight cells

If(issuetype = "story" and status = "Cancelled", "{panel:bgColor=#FFFF00}1{panel}"),
issuetype = "story" and status != "Cancelled", 1,
itemtype != "issue", SUM{COUNT#children{IF(issuetype='story',1)}})

Thanks,

Poojaa

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

New cloud apps roundup - June 2021

Since our last roundup in April, Atlassian's Marketplace Partners have added over 100 new cloud apps to the Atlassian Marketplace to help your teams work more efficiently. Let’s take a quick look a...

487 views 6 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you