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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!