Formula Help

I need a formula that says, if end date is one day away, and %complete is less than 50% done, then change the Health column cell

to red. If %complete is 100%, then change Health column cell to blue, otherwise keep health column cell green. Can someone help?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!