Struggling with if formula to show overdue task and activate red flags
I have been playing around with the IF formula and thought I finally got the hang of it. However my "overdue" statement is not working and just set's it to "In Progress" when percent complete is not 100% on Todays date. I also want to do an At Risk statement but need to figure out what is wrong with the current formula.
The example I used is
=IF([Percent Complete]@row = 1, "Complete", IF(AND([Percent Complete]@row < 1, [Finish Date]@row < TODAY()), "Delayed", IF(AND([Percent Complete]@row < 0.5, [Finish Date]@row <= TODAY(5)), "At Risk", IF(AND([Percent Complete]@row < 1, [Finish Date]@row > TODAY(7)), "In Progress", ""))))
This is my current formula, I tried it with just TODAY() but that did not work either just sets it to in Progress.
=IF([Percent Complete]@row = 1, "Complete", IF([Percent Complete]@row = 0, "Not Started", IF([Percent Complete]@row > 0.01, "In Progress", IF(AND([Percent Complete]@row < 1, [End Date]@row <= TODAY(1)), "Overdue"))))
and
=IF([Percent Complete]@row = 1, "Green", IF([Percent Complete]@row = 0, "Blue", IF([Percent Complete]@row > 0.01, "Yellow")))
If you can assist, I feel like I am going in circles here
Answers

The way If statements work is that it will look for the first True statement. and then continue from there. I would move where you have the overdue statement. What's happening is that it is finding the In Progress statement as true so it stops searching for the false "The over due" Try this instead.
=IF([Percent Complete]@row = 1, "Complete", IF([Percent Complete]@row = 0, "Not Started", IF(AND([Percent Complete]@row < 1, [End Date]@row <= TODAY()), "Overdue", IF([Percent Complete]@row > 0.01, "In Progress"))))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Awesome going to try that  thank you so much!!!
Will let you know if this solves it.
Much appreciated.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!