Need help with RYG status formula.
I am using this formula currently to change a harvey ball based on dates. It is currently working, but I am modifying my sheet to include rows that I want to ignore for now, meaning that some date fields will be blank. I would like for the formula to return no harvey ball color when there are no dates in the cells to calculate. This seems simple but I appear to be having trouble with it.
Can anyone offer any guidance?
This is the working (existing) formula:
=IF([Next PM Due Date]@row < TODAY(), "Red", IF([Next PM Notification (Due Within 30 Days)]@row <= TODAY(), "Yellow", IF([Next PM Due Date]@row > TODAY(), "Green")))
If I clear out the dates using this formula, the "Status" cell will still maintain the last harvey ball color in it. I would like for it be blank when no dates are entered.
Help Article Resources
Check out the Formula Handbook template!