Formula for status color


Hello, I am looking for the right formula to make the Status color change. My goal is to have the color change based on the days since updated. So the status will be green 0-179 days. Then Yellow when the days since updated is 180+ days, and turn Red if it's 360+ days.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!