IF Function

bbloch18

I am trying to create an IF Function for Various Statuses (Not Started, Hold, Complete) - When selected, Drop Down changes to Gray ball for Not Started, Yellow ball for Hold, Red ball for complete

SmSulli

=IF(Status1 = "Not Started", "Gray", IF(Status1 = "Hold", "Yellow", IF(Status1 = "Complete", "Red", "")))

bbloch18

Thank You!  The formula worked; how do I associate it with the correct column?



I have a Status column with the words: Hold, Not Started, In Process, Complete.  When I flip those statuses, I want the first column to display the color bullets.  Does that make sense?  Which column should the formula go?

 

bbloch18

I got this to work.

 

Thanks!

Barb