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

edited 12/09/19 in Archived 2017 Posts

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

Please help


  • Schultis

    Thank you.  Could you help me with this question?





    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



    =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





This discussion has been closed.