Is there a way to see who deleted a formula whose output was blank?

SYSPK

I have many formulas on my sheet, one of which keeps getting deleted in random rows throughout. The output is often blank to begin with so cell history doesn't tell me who deleted the formula there. And the sheet is so busy that the activity log doesn't help- since the histories of each row are fitted into 1 cell which gets maxed out with characters.

Is there a way to figure out who is clearing out the formulas? Unless it's a bug.

Thanks

Paul Newcome

Have you tried filtering the activity log to only show cell changes?

What if you changed the output to be some random symbol and then used conditional formatting to "hide" that symbol so that it appears blank? Then you could track in cell history or use an Automation to alert you whenever that column changes from the symbol to blank.

So replace "" with "BLANK" in your formula then set up conditional formatting so that when the cell contains BLANK, change font color to white or whatever color the cell fill is which will make the cell appear blank.

Andrée Starå

Hi @SYSPK

Maybe you could trigger a copy row action to another sheet and see it there?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

SYSPK

@Andrée Starå I don't think so, since the output in that cell was blank to begin with and deleting the formula leaves it blank.

Paul Newcome

Have you tried filtering the activity log to only show cell changes?

What if you changed the output to be some random symbol and then used conditional formatting to "hide" that symbol so that it appears blank? Then you could track in cell history or use an Automation to alert you whenever that column changes from the symbol to blank.

So replace "" with "BLANK" in your formula then set up conditional formatting so that when the cell contains BLANK, change font color to white or whatever color the cell fill is which will make the cell appear blank.

Andrée Starå

@SYSPK

Ok. Let us know if you find a solution!