Formula for Structure Board

[Ahmed Raza]

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

[Stepan Kholodov _Tempo_ · Accepted solution]

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]

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