1. Is there a way to sum up values of sub-tasks (for e.g., revenue)to add it to the task issue without using Script runner ?
2. Also is there a way to count the number of labels attached to an issue ?
Thanks in advance!
Hi Shravya - Welcome to the Atlassian Community!
1. Yes, you can do that with the Automation For Jira tool built into Jira Cloud.
Now when each issue is created, it will add the desired default label as long as the issue is created in that project. You might need to refresh the page after each issue creation to see it.
You can do this via global rules to apply to all projects also. You'll need to be a Jira Admin/Site Admin, then instead of going to Project Settings, go to Jira Settings (cog icon on left-hand navigation bar) > System > Automation Rules (left-hand menu).
For more on using Automation For Jira see these help pages.
2. I am not aware of any way to count those.
I understand this solution you mentioned, but i was looking more like summing up the values of my Custom Field "Revenue". The context is something like , we have a task for the product team and multiple sales users would create sub tasks for each of their client requirements and the revenue for all the sub tasks can be added to the parent task automatically. Is that possible ?
For 2, my use case is to understand how many users are asking for a product feature and labels was one way i thought could help (multiple sales guys would be adding their customers who require that product feature and we thought addition of all labels of customers). Is there any other way I can use it ?
Thanks in advance!
Yes, every time the value of one field is updated, you can add it to the value of another field. So if you have a total field that has a value of 10 and then you change the value of a different field from 0 to 5, you can have the total field up date to add the current value plus the new value of 5 to make it 15.
I am trying to use the same type of calculation to sum numbers from a custom field called ROI. See screenshot. However when I use the Smart Value it isn't summing, I'm sure I'm missing something, it just keeps adding "+ number value" into the string in the parent. How could I make it so that when the child value is changed the parent value totals the new addition?
Ah! Yes good catch ok that solves my addition problem. One follow up, hoping you may know? If I have $500 in a child and $400 in a child, they'll total into my parent as $900. However if I go back to one of the children and change the value it just adds again b/c I'm using an addition smart value. Is there a way for it to recalculate as well? Or would I need something else to do this?
Thank you SO much.
John, I am not seeing how this answer applies to my question. I am trying to add 5 fields together in my ConfiForm, nothing to do with JIRA. I tried formula ([entry.Amount1] + [entry.Amount2] + [entry.Amount3] + [entry.Amount4] + [entry.Amount5] ) but received error:
"Expression: [100+100+++] could not be calculated, Unknown operator '+++' at position 8"
You should really ask this as a new question, but what this means is you can "optional" fields and if you dont provide the values for all fields they stay empty and will fail.
What you shall be doing is to wrap these field values into ZEROIFEMPTY() function
(ZEROIFEMPTY("[entry.Amount1]") + ZEROIFEMPTY("[entry.Amount2]") + ZEROIFEMPTY("[entry.Amount3]") + ZEROIFEMPTY("[entry.Amount4]") + ZEROIFEMPTY("[entry.Amount5]"))
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
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