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.

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!