Rookie Stage - Status RYGB

Schultis

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.

 

Kat Komlo

That's a formula for example (depending on your colums) 

Kat Komlo

note that 3 refers to the row number because I was hovering over the status cell on that row to view the formula

Schultis

very new to formulas do i put at top of column so that all rows follow this

 

Schultis

Kat, would you be interested in setting the formulas in my sheets and I would pay you for your time?

Kat Komlo

You put your formula in the cell you want to display the answer.  So if you want the formula for the entire Status column write your formula in the first cell on the first row of your column.  Then in the lower right hand corner of that cell when you click once on it and hover you'll get a big plus sign.  Click on it and drag it down to the last cell in your column.  Let go and now the formula is in all those cells in the column.  If your sheet has hierarchy in it you may or may not want the formula in the cell on the parent row.

You can also copy a cell the formula is in and paste it to another cell.

 

Thanks for the offer Schultis.  I'm not the best formula writer.  I'm lucky, in that, I manage and work with programmers; they're really good with logical statements 

Kat Komlo

Go to Smartsheet Template and under Featured Templates there is a sheet called Smartsheet Formula Examples.  Use that template; lots of help and examples there and it shows you how they actually work not just abstract equations