App script - atomatically add value of a cell to another sheet, create a list

[kylerisi]

Hi Guys,

This is a massive long shot since my question refers to using google sheets

I was wondering if anyone had any experience creating App Scripts within Google sheets.

I need to be able to detect any changes in the value of ('Dashboards'!L56) and then add this change to ('Search List'!a1) along with a date and time stamp in ('Search List'!B1). Every time the cell is edited or changed I need to add this change to the next available row in my list.

I have tried reaching out on the google forums but nobody is biting.

Can anyone please advice me on how to create this or advise on where else I can look.

Best Regards

Kyle