Health Status Formula


Hello, I need to create a health status column (RGY) that correlates to the finish date, percentage (0-100), and status (not started, in progress, complete). Please help me out with a formula because this has been so confusing.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!