Formula tool bar missing

Schultis

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

Please help

Kat Komlo

Schultis

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

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