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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!