Flag Red if under 100% or Past Due
Hello!
Here is what I am trying to accomplish!
In the column with the flags (highlighted yellow), I would like the flag to turn red when the Percent Complete Column (highlighted Green) is less than 100% OR if the Completion Date Column (Highlighted Blue) has a date past today's date.
Please let me know if you can help with this!
Comments
-
Hey Paul,
Huge Apologies! I was posting on this forum on behalf of a manager and there was a misunderstanding when he was telling me what he intended the formula to do.
So I don't know if you could help me with this, but what I really need is:
The flag highlights red if 1) Today's date is past the completion date (so the task is overdue) AND 2) the % Complete column is less than 100.
You can use the same attached image for reference. Again, hope I didn't waste too much time on that first question!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!