IF Statement with Color Symbols

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.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!