I’d like to keep tracks of changes made by users in a table
I have tried to use ChangeCounter linked to a Workflow and separately a Workflow set to ALL_CHANGES and adding a new row to a sheet called Changes.
But neither are really successful as I don’t really know which column has changed and what it is was changed from.
The only was I can see to do this is to use a ChangeCounter set to each column and check them all individually.
Is there a better solution I haven’t found yet?
Many thanks for your assistance