Formula to Automatically Update Red, Yellow or Green Symbols

Brandon G.
Brandon G. ✭✭
in Formulas and Functions

I am having a difficult time getting the right formula for this. I would like to make it so if any of the dropdown options are selected that contain the word "Dead" then a red symbol auto populates in the column to the right. Any help would be greatly appreciated!

20241027_113408.jpg
· Share on FacebookShare on Twitter

Best Answer

  • Michelle Choate 2
    Michelle Choate 2 Community Champion
    Answer βœ“

    =IF(CONTAINS("Dead", Status@row), "Red")

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with! Book time with me here: https://calendly.com/michelle-choate

    · Share on FacebookShare on Twitter

Answers

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!