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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!