Hi there! I am working to automate the RYGG balls and its like I can get parts of the formula to work separately but not all together. I added a Past Due column to use to try to refer to that indicator to get the formula to be a little less complicated. The goal is:
If Due Date is blank =then no balls or ""
If the Due Date is less than the Actual Complete Date =Green
If the Past Due flag is true or 1=Red
If the Estimated Complete Date is within 5 days of today's date Yellow
Gray will be for N/A tasks
This one worked for me at one point but I have added some columns, so it is no longer working correctly
=IF(ISBLANK([Due Date]@row), "", IF([Past Due]19 = 1, "Red", IF([Actual Complete Date]@row > [Due Date]@row, "Green", "Yellow")))