Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula tool bar missing

Options
Schultis
Schultis
edited 12/09/19 in Archived 2017 Posts

I am rookie, but I cant find the formula toolbar only the conditional formatting.

Please help

Comments

  • Schultis
    Options

    Thank you.  Could you help me with this question?

     

     

    0

     

    I dont even know where to start:

     

    Column Stage         Column Status Dropdown List

    RED Ball                   Not Started

    Green Ball                In Progress

    Yellow Ball               Waiting

    Blue Ball                   Completed

     

    How and Where do I put in a formula to select from Status dropdown list Not Started and have

    the Red Ball show up automatically in Column Stage?

     

    I know this must be simple.  But have no I idea where to start.  Please help asap.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 04/01/17
    Options

    Schultis,

     

    =IF([Status]23 = "Not Started", "Red")

     

    for row 23

     

    Be aware the if you manually change the Stage column to a different (or no) color, the formula will be overridden (and gone).

    What you want is Nested If's for each drop down selection and its corresponding RYGB color.

     

    See this article for help on Nested If's

     

    https://www.smartsheet.com/blog/support-tip-build-nested-IF

     

    Craig

This discussion has been closed.