Help creating a formula that generates the current fiscal year

Christina S.

The following formula is #UNPARSEABLE. I'm not sure why. Please help.

=IF(MONTH(TODAY())>=7, YEAR(TODAY())&"-"&(YEAR(TODAY())+1), (YEAR(TODAY())-1)&"-"&YEAR(TODAY()))

Carson Penticuff

The concatenate operator in Smartsheet is + instead of &.

=IF(MONTH(TODAY())>=7, YEAR(TODAY())+"-"+(YEAR(TODAY())+1), (YEAR(TODAY())-1)+"-"+YEAR(TODAY()))

Carson Penticuff

The concatenate operator in Smartsheet is + instead of &.

=IF(MONTH(TODAY())>=7, YEAR(TODAY())+"-"+(YEAR(TODAY())+1), (YEAR(TODAY())-1)+"-"+YEAR(TODAY()))

Christina S.

Thank you, @Carson Penticuff!