Formula is not working
Hi  I cannot figure out why this formula won't work 
=IF(AND(TODAY(10) >= [End Date]@row, IF([% Complete]@row, <0.75, "yellow")))
Thanks for your help!
Best Answer

When creating IFs, you need to make sure you have at least a criteria and a true condition. The syntax is IF(logical expression, true condition, false condition). When using AND to specify two criteria, you have to make sure you close out the AND before going to your true condition.
Try this. The part in BOLD is your criteria. See the AND(...) is closed off, with your two logical expressions that must be true inside of it, separated by a comma. The closed off AND(...) is followed by a comma, and then in italics is your true condition.
=IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row <0.75), "yellow")
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers

When creating IFs, you need to make sure you have at least a criteria and a true condition. The syntax is IF(logical expression, true condition, false condition). When using AND to specify two criteria, you have to make sure you close out the AND before going to your true condition.
Try this. The part in BOLD is your criteria. See the AND(...) is closed off, with your two logical expressions that must be true inside of it, separated by a comma. The closed off AND(...) is followed by a comma, and then in italics is your true condition.
=IF(AND(TODAY(10) >= [End Date]@row, [% Complete]@row <0.75), "yellow")
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Thank you a million times over!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!