Tracking edits/editors to cell history?

Tim Silvester

I'm wondering if there's a way to create a formula to tally (via cell history) who is making edits to a column within a spreadsheet.

I am observing a lot of edits to a critical column of cells, which are clearly traceable when right-clicking on a cell history. My job (as a planner) is made very hard when anyone in our department can edit commitment dates, and I want to be able to factually show to the team, with real number and figures, the degree of editing that is occurring, and why this is a problem.

I'm hoping there's a way to create a COUNTIFS formula to track cell edits / editors. If I can visibly track the problem and present it as a metric, i'm hoping it might discourage the behavior.

Andrée Starå

Hi @Tim Silvester

I hope you're well and safe!

• You could use a Workflow combined with the Copy Row Action and a so-called helper sheet. When something changes in the column, the Workflow copies the row over to the helper sheet.

Would that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

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