Struggling with If statement

Kelly Ospina
Kelly Ospina ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to create a formula to check a box in one column if a date in another column is greater than a specific date. 

Here is what I have, that is not working: 

=IF(ISDATE([Estimated Close Date]1), IF(AND([Estimated Close Date]1 = >DATE(2018, 6, 1), 1)))

Estimated Close Date is a date column. The formula I am trying to build is in a check-box column. 

Basically, what I am trying to do is ascertain if the Estimated Close Date in the date column falls within our fiscal year or not. I have one check box column to check if date is greater than fiscal year start, then another if less than fiscal year end, and a third column to check if both previous boxes are checked. Probably not the best way to do this, but I really struggle with formulas of this nature. 

Any and all help is appreciated. 

Link to published view of sheet: https://publish.smartsheet.com/c057994f5a78412db46de247aa5c041e

 

 

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!