Need help with IF formula using dates
We want to know if someone's annual review is "due"
The Update date is when they upload the annual review and this populates from completion of a form. This is working correctly.
The "next due date" is when it is due and this is working correctly.
The problem is with the "testing IF formula for update" column formula.
The current formula works to say if they upload it prior to the due date it is due and if they upload it after the due date it is not due.
What I prefer to say is if they upload it within 30 days prior to the due date, it is also not due.
=IF([Update Date]@row <= [Next Due Date]@row, "due", "not due")
Can you assist?
Thanks!
Best Answers
-
Try this:
=IF([Update Date]@row <= [Next Due Date]@row - 30, "due", "not due")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Try this:
=IF([Update Date]@row <= [Next Due Date]@row - 30, "due", "not due")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks SO much!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!