How do I flag a row once a percentage in another row hits a certain percentage?

I'm trying to trigger the red flag to show up once a row is 80% or higher. I tried using conditionally formatting, however, the flag symbol isn't an option. I also attempted a few different formulas, which didn't work. I want the red flag to populate once a percentage from the same row is hit.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!