dojones — Smartsheet Community

Skip to content

Overview

Overview
Roles	Member
Badges	14

About Me

About Me
Not much happening here, yet.

Analytics

137

Posts

287

Visits

449

Points

Jan 20, 2024

Join Date

Mar 3, 2025

Last Active

Re: Create a fiscal year formula

dojones

06/30/24

You can change Year in Date function to a formula. =IF(Date@row < DATE(YEAR(Date@row), 7, 1), YEAR(Date@row), YEAR(Date@row) + 1)

1 ·
Re: Create a fiscal year formula

dojones

06/30/24

Try this. =IF(Date@row < DATE(2024, 7, 1), YEAR(Date@row), YEAR(Date@row) + 1)

1 ·