Need help with RYG status formula

=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


  • Genevieve P.
    Genevieve P. Employee Admin

    No problem! Glad it worked for you 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!