# Struggling with If statement

✭✭✭✭✭
edited 12/09/19

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

Tags:

• try

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

• ✭✭✭✭✭

That did it, thank you!

Could you tell me, is it possible to modify this formula to check the box if the date in Estimated Close Date is less than one date, greater than another?

• =IF(ISDATE([Estimated Close Date]1), IF(AND( [Estimated Close Date]1 >= DATE(2018, 6, 1), [Estimated Close Date]1 < DATE(2019, 5, 31)),1, 0), 0)

• ✭✭✭✭✭

THANK YOU! You have no idea how much you have just simplified something I've been grappling with for weeks.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!