IF formula for between dates
ss1992
ββ
I have dates in one column of a SmartSheet. I need a formula that tells me if the date is less than today and less than 10/25/22, return "Yes", if not than "No"
Essentially I need the formula to return yes or no if the date is in the past and if the data is coming up within the next two weeks.
Can someone please help with this? Thank you!
Best Answer
-
This would output "Yes" for dates that are in the past or in the upcoming two weeks...
=IF([Date Column Name]@row<= TODAY(14), "Yes", "No")
Answers
-
This would output "Yes" for dates that are in the past or in the upcoming two weeks...
=IF([Date Column Name]@row<= TODAY(14), "Yes", "No")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
