At-risk Formula Help
I know this has been posed 7 million times already, but I need help with an at-risk formula...
I would like a flag in the "At Risk" column to automatically populate if the following criteria is met for that given row:
IF a row's "End Date" is within 15 days from today’s date AND "% Complete" for that row is less than 50%
OR a row's "End Date" is in the past
OR that row's "Status" column is yellow or red
**no row should flag as at risk if the above criteria is not met
Help Article Resources
Check out the Formula Handbook template!