I am having trouble with a formula. I am not sure what the heck I am doing wrong here, but I know there are some formula geniuses here that can help me lol.
I am trying to return a Red ball if the category is an output or project and the expected completion date is in the past. If it's not, I want it to pull whatever is in the Health column.
=IF(AND(Category@row = "Project", [Expected Completion Date]@row < (TODAY())), "Red", Health@row), IF(AND(Category@row = "Output", [Expected Completion Date]@row < (TODAY())),"Red", Health@row)
I feel like I need an OR in there somewhere?
Help Article Resources
Check out the Formula Handbook template!