IF Function

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

Find more posts tagged with

Formulas

Comments

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