IF Statement with Color Symbols

Matt Atkins

I am having difficulty getting the following function to work.

=IF([End Date]@row > TODAY(), "Blue", IF([End Date]@row < TODAY(), "Red"), IF(Done@row = 1, "Green"))

The blue and the red function work perfectly, but when adding the green if statement comes back with "# Incorrect Argument Set". The odd thing is that if I only apply the green statement to the row, it works fine.

Mark Cronk

Hi @Matt Atkins ,

Try:

=IF(Done@row = 1, "Green", IF([End Date]@row > TODAY(), "Blue", "Red"))

When using nested IF statement the order matters. The function stops as soon as it finds a true statement.

Work?

Mark

Matt Atkins

Perfect, I should have asked sooner!

Mark Cronk

Hi @Matt Atkins ,

Try:

=IF(Done@row = 1, "Green", IF([End Date]@row > TODAY(), "Blue", "Red"))

When using nested IF statement the order matters. The function stops as soon as it finds a true statement.

Work?

Mark

Amber Benge

Mark is on it! Let us know if that solves it.

Matt Atkins

Perfect, I should have asked sooner!

Mark Cronk

Hi Matt, Glad you found a solution. Would you tag my response as accepted? Appreciate you contributing to the Community.

Mark