I have a google spreadsheet with multiple sheets.
On one of the sheets, we use Zapier to populate new rows of data when a meeting is scheduled with our team. I'd like the sheet "Meetings" to automatically sort by date, descending in column P (16). The sheet is A:AW.
When a new line is added by Zapier it is not in order by date.
I would like 1 sheet, "Meetings", to be auto-sorted whenever a new row is added.
I'm looking for a script and how to add it to the worksheet that will help auto-sort the sheet by date.
Every time I open the sheet I'd like it to be sorted by column P in descending order.