Red Green Blue dot question

JimTod

I want to write a formula to return a Green dot if date is less or equal to another date, and a Red dot if the date is greater to the other date, and return a Blue dot if the cell is blank.

Katy H

You had an extra parenthesis after Blue. Try this:

=IF(ISBLANK([start date]@row), "Blue", IF([start date]@row <= $[start date]$1, "Green", "Red"))

Katy H

Can we give these date columns names to help build the formula?

The answer would be to create an embedded IF statement in the column that displays the dropdown colors.

JimTod

Here is the formula i am trying.

=IF(ISBLANK([start date]@row), "Blue"), IF([start date]@row <= $[start date]$1, "Green", "Red"))

Katy H

You had an extra parenthesis after Blue. Try this:

=IF(ISBLANK([start date]@row), "Blue", IF([start date]@row <= $[start date]$1, "Green", "Red"))

JimTod

Thank you very much. That worked.