Flag out of Range Date

Options
Lisi
Lisi
edited 12/09/19 in Formulas and Functions

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))

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!