Out of Practice, Need 2 Variable Flag (At Risk) Help


I haven't been a good girl practicing my formulas. Everything I've tried is coming up Uparseable.

What I'd like to do: Red Flag when "Expected Completion Date" is within 5, days, or in the past, and "Current Status" does NOT equal "Complete".

I'm feeling pretty silly that I've spent so much time trying to get this to work. I'd love any help offered on a working formula



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!