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

Options

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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!