Hey folks, question here.
Trying to use Comments in one specific jira ticket (issuekey=DB-1250) as a reference kind-of-table, as a place to store historical stats about the duration of tasks of different size.
Something like
S:5
M:12
L: 27
Each of these sizes are posted as a separate comment to this DB-1250 ticket.
Then I have hundreds of other tickets within the same project, which are marked with task sizes. No links or hierarchy to this reference DB-1250 ticket.
Logic I'm tryig to apply is:
Knowing all ticket sizes (S,M,L) from the project,
Retrive the apropriate comment from DB-1250 by keyword "S:", "M:", "L:"
And put this number into formula to calculate the total duration for all the tickets I need.
What I cannot understand is how to "hardcode" this issuekey in complarison formulas.
Is there a way to compare all the tickets against that specific one and how to refer to that specific issuekey in formula?
Maybe a hint you can give?
In Structure for Jira, create a formula column to calculate ticket durations based on task sizes.
Since formulas cannot directly read comments from another issue (DB-1250), preprocess the data (e.g., S: 5, M: 12, L: 27) into a custom field.
Use a formula like IF(Size = "S", 5, ...) to map sizes to durations and calculate totals.
So ideally you have to research on preprocessing methods / tools for this use case.
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.