At Risk Flag & IF Function
Options
Comments
-
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.
-
-
Haha. Yes. I have been there too! #trialAndError
-
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.