Flag out of Range Date
Lisi
✭
Hello,
I have a date range:
Date Range Start & Date Range End, and I want to flag it if the "Actual Completion Date" is before the Date Range Start OR if the "Actual Completion Date" is after the Date Range End.
Can anyone help?
I've tried:
=IF([Actual Completion Date]@row > [Date Range Start]@row, OR([Actual Completion Date]@row > [Date Range End]), 1,0))
=IF(AND([Actual Completion Date]@row > [Date Range Start]@row, OR([Actual Completion Date]@row > [Date Range End]), 1,0))
Tags:
Comments
-
Hi Paul,
Thank you! That works, but what can I add so it does not flag if there is no date in Actual Completion Date?
-
Makes sense!
Thank you very much
-
Excellent! Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 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!