Formula for Structure Board

Ahmed Raza_28mdvf

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

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)