Automate checking a box if date column is less than 2 weeks?
I have a check box column (can be changed to symbol if needed), and Id like the box to check if the date in another column is less than 2 weeks from the current date.
What would the formula be?
Thank you!
Best Answer
-
= IF([Date Column]@row <= TODAY()+14, 1, 0)
This will leave the box checked as you move forward, so if you do not want dates in the past you want to switch to something more complex:
= IF(AND([Date Column]@row >=TODAY(),[Date Column]@row <=TODAY()+14), 1, 0)
Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
Answers
-
= IF([Date Column]@row <= TODAY()+14, 1, 0)
This will leave the box checked as you move forward, so if you do not want dates in the past you want to switch to something more complex:
= IF(AND([Date Column]@row >=TODAY(),[Date Column]@row <=TODAY()+14), 1, 0)
Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!