At Risk Flag & IF Function

Paul Newcome

Haha. I've done it plenty of times. Post on the first error I see and not even pay attention to the rest of the formula. I do it to myself pretty regularly when correcting issues with my own work.

 

Oh. There's an error? Well this should take care of it.

...

Why isn't it working now?!?

...

Oh... Because I fixed the error in one part of the formula, but not the other part. Oops.

Paul Newcome

Happy to help! 

Mike Wilday

Haha. Yes. I have been there too!  #trialAndError

Michael Willett

So this formula works great with one exception. When the progress is 100% (ie: completed) is still appears to be flagged. Id like a small mod: If the progress if < "Three Quarter" rais the flag, is its "Three Quarter" or "Full" keep the flag unraised.