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
    Dawn Skirvin ✭✭

    Thanks so much!!

  • No problem! Glad it worked for you πŸ™‚

    Need more information? πŸ‘€ | Help and Learning Center

    こんにけは (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!πŸ‘‹ | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!