Symbols for Status

Options
Julie Bettinardi
Julie Bettinardi ✭✭
in Formulas and Functions
Smartsheet Screenshot.jpg

Why are my words not translating through to symbols? The formula seems to work since its returning the text, but ist converting it to symbol form

=IF(Status@row = "Assigned / Not Started", "Empty", IF(Status@row = "In-Progress, On-Schedule", "Green", IF(Status@row = "Delayed", "Yellow", IF(Status@row = "Complete", "Blue", IF(Status@row = "Paused", "Full", "")))))

Tags:
· Share on FacebookShare on Twitter

Best Answer

Answers

  • Etienne Mermillod
    Etienne Mermillod ✭✭✭✭✭
    Answer ✓
    Options

    Hi Julie,

    Is the column of the correct type (symbols) ?

    image.png


    A simple column formula is working on my side:

    image.png


    · Share on FacebookShare on Twitter
  • Julie Bettinardi
    Julie Bettinardi ✭✭
    Options

    Ohhh - I see. You're correct, I didnt have it as a symbol column. I was trying to avoid selecting one of the symbol category options because I wanted symbols across multiple categories (Circles in Green, red, yellow, blue, light grey, and dark grey). I was hoping a formula would solve for that but it appears not.

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