I am using the onedit function which in google sheets works perfectly. However im using appsheet to edit the tables in google sheets.
When I edit and change open to closed, the row should move to another sheet.
This works fine if i change the text in the table.
When using the form in appsheet it works in a way that the data changes, but the script onedit does not run.
Is there a better funstion or even a function at all to get sheets to understand that the value has changed?
User | Count |
---|---|
44 | |
30 | |
24 | |
23 | |
13 |