Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Formula for Structure Board

Ahmed Raza
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!
August 20, 2024

Hi All, hoping you can assist. I would like to write a formula that would reference the Target Start field input and convert that to a Fiscal Year output.

Example: If the Target Start = 07/01/2025, then formula column should output FY25Q3

Context around fiscal year:

Q1 = July to Sep

Q2 = Oct to Dec

Q3 = Jan to Mar

Q4 = Apr to Jun

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
0 votes
Answer accepted
Stepan Kholodov _Tempo_
Community Champion
August 21, 2024

Hello @Ahmed Raza 

You can try a formula like this:

if year(targetstart) = 2025:
if month(targetstart) > 0 and month(targetstart) < 4: concat("FY25","Q3") else
if month(targetstart) > 3 and month(targetstart) < 7: concat("FY25","Q4") else
if month(targetstart) > 6 and month(targetstart) < 10: concat("FY25","Q1") else
if month(targetstart) > 9 and month(targetstart) <=12: concat("FY25","Q2")

I hope this helps. If you need further assistance with the formula or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

Ahmed Raza
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!
August 21, 2024

Hi @Stepan Kholodov _Tempo_ , thank you so much, worked perfectly. 

Like Stepan Kholodov _Tempo_ likes this
TAGS
AUG Leaders

Atlassian Community Events