Formulas in Structure referencing a global variable

sagias
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 14, 2024

Hi,

I am creating a Structure with a set of filters and formulas. These are dependent on the current quarter (e.g. Q1-24 right now). I would like all formulas to key off of a global variable which would be set to this quarter so I don't need to update all the filters and formulas every quarter on a given board.

I know I could use the current date and deduce the current quarter, but I need the variable to be edited manually so I am in control (e.g. towards the end of Q1 I would want to toggle between Q1 and Q2 as both are interesting).

 

Any idea whether and how this could be achieved?

1 answer

1 vote
Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 14, 2024

Hello @sagias 

If you have multiple formulas that use the same potentially changeable quarter, the easiest way to achieve this would be to have the quarter as a value:

- either in issues with which the formulas work;
- or as a folder's Summary in which the whole structure is presented. The formula can then be referenced as a parent item of any issue in the structure.

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)

Julien Huon
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 17, 2024

Not sure I understood the second solution. Let's say I would need 2 global variables, that multiple colum formulas would need the data to calculate, how would you do that with folders and parent references ?

Thanks in advance to clarify with an example as that need of global variables for formulas seems to be more and more requested as an evolution not to have to reconfigure the formulas as soon as the values change.

Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 18, 2024

@Julien Huon 

If you need two variables, you can create a folder in the structure, create another folder in it, and then have the issues added to the second folder. And if you need a formula that works with issues and uses two changeable variables, you can reference the variables when they come from the Summary of each folder like this:

- parent#level=-2{summary} for the value of the direct parent folder and
- parent#level=-3{summary} for the value of the top-level folder. 

Changing the Summary of either folder should result in the Formula column reacting to that change and recalculating its results.

If you need further assistance, please reach out to us directly at our support portal.

Best regards,
Stepan

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events