Why is this formula only giving me a yellow symbol?

Ben13
Ben13 ✭
in Formulas and Functions

=IF([% Complete]@row = 0, "Red", IF([% Complete]@row = 100, "Green", IF(AND([% Complete]@row > 0, [% Complete]@row < 100), "Yellow", "")))

· Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole Community Champion

    @Ben13

    I looked at your formula and I do not see an issue with it. My testing also shows it should work as intended. Could we get a bit more information. Does % Complete column use a formula as well. If so the issue could be it is reading the formula as text instead of a Value.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!