Fiscal year

Options

Hi,

Can anyone help me with this?

I need to automatically record the fiscal month of a product based on its Offline Date, which indicates the month it is due.

Our budget years are from October

=IF(MONTH([Offline Date]@row)=> 10, "Fiscal Year " & (YEAR([Offline Date]@row) + 1), "Fiscal Year " & YEAR([Offline Date]@row))

This formula does not work

Tags:

Best Answer

  • ker9
    ker9 ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @David Clunie

    Please try the formula below. Smartsheet uses "+" instead of "&" to join.

    =IF(MONTH([Offline Date]@row) > 9, "Fiscal Year " + (YEAR([Offline Date]@row) + 1), "Fiscal Year " + YEAR([Offline Date]@row))

    Hope this helps!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!