I created a formula, but have problems. The formula is ........ =IF([Status Date]@row >= [email protected] - 14, "Red", "Green") ....... The formula work fine in some rows, but not all. I'm puzzled as to why this is the case. Does the master sheet need to be purged for underlying errors of some kind. I can't duplicate the error message in a test sheet. The error message is ..... #INVALID OPERATION ......
Also, when a blank [Status Date] cell is encountered and the (Today) cell is populated, the RGB ball always goes to "Green". Same is true if (Today) cell is blank and [Status Date] is populated. If both reference cells are blank, the RGB ball goes to "Red". I would like the blank cell to remain blank if possible and work accordingly with the formula for populated cells. I guess I need to learn more about how a blank cell is treated. But I'm still puzzled about the error message on certain cells that appear to be benign. Thanks for any help.
=IF([Status Date]@row >= [email protected] - 14, "Red", "Green")