Sign in to submit new ideas and vote
Get Started

Create a fiscal year formula

swfascetti
swfascetti ✭✭✭✭✭

I include fiscal year on most of my sheets. Our fiscal year starts July 1, so I write a formula such as FY = if(Month(date)<7, Year(date), Year(date)+1). Would it be possible to create a FY formula in Smartsheet that returns the FY when provided a date and the FY start? FY(date,FYstart) as FY( mm/dd/yyyy, fymm/fydd )? Or, set FY start date set for our organization to simplify the formula?

Tags:
4
4 votes

Idea Submitted · Last Updated

Comments