If statement based on date

I am trying to create a formula within my "Academic Year" field so that if the "Date" is more than August 25, 2019, the Academic Year field contents will be "2019-20" -- otherwise, the field contents will be "2018-19".

=IF([Date]1 > (2019, 8, 25), "2019-20", "2018-19"

I am using the date format (2019, 8, 25) based on what I found online for working with dates in Excel. Not sure if that's the same for Smartsheet.

Advice appreciated!

Find more posts tagged with

Education

Formulas

IT & Operations

Comments

Mike Wilday

Try this...

=IF([Date]1 > Date(2019, 8, 25), "2019-20", "2018-19"

Mary Ayers

Perfect!! Thanks so much!

Mary

Mike Wilday

You're welcome!

Sign in to join the conversation!

Quick Links

Trending discussions

INCORRECT ARGUMENT SET on an =IF function
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…
Automation not triggering when % Complete shows '100% instead of 100%
I have an automation set up so that when the Status column changes to Complete, Canceled, or Not Needed, Smartsheet automatically updates the % Complete column to 100% (Text/Number column type). After that, another workflow should trigger to alert the next person that their task is ready. This worked fine before, but…
Index Match - # NO MATCH error
Hello, My index match formula cross sheet is giving error since yesterday. =INDEX({VER DT4DT Tools Range 1}, MATCH([App CI]@row , {VER DT4DT Tools Range 2}, 0)) I have checked the format of columns in both sheet and also retyped formula. any advice?