Trying to Clear a "Ball in Court" cell when item is complete

Kait Bankey
Kait Bankey ✭✭✭
edited 12/09/19 in Formulas and Functions


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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!