I would like to have it that when a row is edited that it only copies the name phone and adds a timestamp of the edit on another tab in Google Sheets.
The above is working but i cannot figure out how to get the timestamp to show. It also creates a row no matter what tab I am in and I want it to only read edits from the main.![]()
Please Login or Register to view this content.
The outcome should display the roadname, phone and then C:C should have timestamp of changed made.
I have updated the below sheet to show expected outcome
https://docs.google.com/spreadsheets...gid=1523701088
Bookmarks