How to turn off Harvey Ball from showing in blank columns?

EllanaV

For existing rows that have the "none" clicked in the Column with a harvey ball symbol, it doesnt trigger the check mark or grey ball to go away in a blank row. And it wont let me manually turn it off either since the formula is in there. I would like for these two columns(risk and done) to be empty when there is no date in the "Abstract Due Date" column.

Screenshot 2023-12-06 095532.png

Screenshot 2023-12-06 141249.png

Screenshot 2023-12-19 115107.png

Thank you so much for your quick response!

Eric Law

https://community.smartsheet.com/discussion/114612/how-to-turn-off-harvey-ball-from-showing-in-blank-columns

I don't know what your formula is, but there are 2 ways you can do this.

1) In your automations, when Done is checked, clear cell value in the harvey ball column

2) Add the following to your formula in the harvey ball column. =IF(Done@row = 1, "", {Your current formula minus the = sign})