Need help with RYG status formula

Options

=IF([% Complete]@ROW<.7, "RED"), IF ([% Complete]@ROW< 1>.7, "YELLOW"), IF([% Complete]@ROW)=1, "GREEN"),"")))


If below/above certain percentages, attempting to change the ball to red/yellow green

Best Answer

Answers

  • Dawn Skirvin
    Options

    Thanks so much!!

  • Genevieve P.
    Options

    No problem! Glad it worked for you 🙂

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!