Trying to Clear a "Ball in Court" cell when item is complete
We are trying to set up a formula to clear the "Ball In Court" when a line is complete. I know that you cannot format a formula in a contact cell, but there has to be a way! It's appearing as though work is still needing done and it is not plausible to remember to clear the cell each time something is complete.
Any suggestions for solutions?
Help Article Resources
Check out the Formula Handbook template!