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.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!