Formula to change status column based on % and date
I want a status column (red, yellow, green), to show up based on two hiring percentage and due date. I think I need to use an IF formula, but I can't seem to get the formula.
Red = less than 25% of goal hired, due date this week
Yellow = less than 50% hired , due date is more than 1 week out
Blue = less than 75% hired, due date is more than 1 week out
Green = 100% hired, and met due date.
Help Article Resources
Check out the Formula Handbook template!