At Risk Flag & IF Function
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
