Seeking a fiscal year formula :-)


I'm looking for a simple formula to generate my fiscal year using the date row.

Fiscal Year Start: Nov 1st

Fiscal Year End: Oct 31

Outcome desired:

If today's date is 8/24/22 - Display FY22 in FY row

If today's date is 11/01/22 - Display FY23 in FY row

Hope that makes sense and thank you in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!