Symbol Formulas

Options
This discussion was created from comments split from: Working with Symbol Formulas.

Answers

  • alexandra.richardson
    Options

    Hi! I'm fairly new to SmartSheet and formulas and could use some help. In one column I have "Progress" at the top column and am using the red, yellow, green balls. Next to it I have "Current Status" with some dropdown options (1 - Not Started 2 - In Progress 3 - On Hold 4 - Cancelled 5 - Completed). I want to make it so that if someone chooses the red ball, the current status will move to "1 - Not Started" and if someone chooses the green ball the current status will move to "5 - Completed." Can you help me with that formula?

  • JamesB
    JamesB ✭✭✭✭✭✭
    Options

    @alexandra.richardson

    In your Current Status Column you would need the following formula:

    =if([Progress]@row = "Red", "1 - Not Started", if([Progress]@row = "Green", "5 - Completed",""),"")

    if either condition is false, you will have a blank in your progress cell.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!