I have a Google Sheets spreadsheet in the following format:
TimeStamp Date Adjust from Adjust to Amount
2/15/2017 19:09:20 15-Feb-2017 Cash Dining Out 5
When a new row is added via AppSheet, I'd like for the data to be extracted to a new sheet and then saved as a CSV file in the same Google Drive folder. A new file for each time it's run is fine. The CSV format should look like this:
Date Desc Amount
15-Feb-2017 Backout Cash 5
15-Feb-2017 Adjust to Dining Out -5
The original row in the first sheet can either be deleted, or you could use an additional column and update this with a flag to indicate it's already been processed.
Prefer use of an onEdit trigger, although a time-based trigger will also be acceptable if it's the only viable solution.
21 freelancer đang chào giá trung bình $15/giờ cho công việc này
I am ready to get started right away.... Can we discuss the project details? My distinction, payment after your complete satisfaction with the resulted task.