Invalid data type when using formula
I am trying to create health status column in my sheet and I want it to generate for me a colored ball in the column and I am using this formula: =IF([% Complete]@row, "Blue", IF([Due Date]@row, <TODAY(), "Red", IF([Due Date]@row <= TODAY(5), "Yellow", "Green")))
I am getting the INVALID DATA TYPE message in some rows, INCORRECT ARGUMENT SET in some rows and in some rows it's working fine. Please advise.
Help Article Resources
Check out the Formula Handbook template!