Health Status

edited 02/19/24 in Formulas and Functions


I am new to using formulas in SmartSheets. I want to have my Health Status reflected "green" when the "employee suspension start" date is within 4 days (for example, employee suspended February 19, 2024 should reflect green through February 23, 2024) then yellow from 5-12 days (previous example February 24 - February 31) then Red from day 13 on (March 1 on). How would you write this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!