Flag or Conditional Formatting?

I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column" and "this column" (where the dates change for each row). Is there a way to do that?

I thought I had figured out a work around by using the flag function but I can't seem to get the formula to work. This is what I'm using:

What am I doing wrong? Any suggestions to either use conditional formatting or the flag function (by correcting the formula)?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!