Need assistance writing a formula w/ Red, Yellow, Green

Algreen7032
Algreen7032 ✭✭
in Formulas and Functions

Column reference is [Open Days]@row

If the number of open days is =< 7, I would like it to show the Green symbol, if between 8 and 29, yellow, and >= 30, red.

Thanks!

Tags:
· Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole Community Champion
    edited 06/11/24

    @Algreen7032

    =IF([Open Days]@row<=7,”Green”,IF([Open Days]@row<=29),”Yellow”,”Red”))

    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
  • Algreen7032
    Algreen7032 ✭✭

    Thanks for responding. Unfortunately it didn't work for me. Getting error: #unparseable

    · Share on FacebookShare on Twitter
  • Mark.poole
    Mark.poole Community Champion
    edited 06/11/24

    I see the issue. I originally used an AND function and removed it. I forgot to remove a ).

    =IF([Open Days]@row<=7,”Green”,IF([Open Days]@row<=29,”Yellow”,”Red”))

    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
  • Algreen7032
    Algreen7032 ✭✭

    Still not working for me. Dang!

    · 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!