Struggling with If statement
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!