@Darren_Murphy,
For each new event insertion, Glide will add a new row below, causing them not to be in order according to the date sequence. Do you have any suggestions for how to tidy this up further, especially to rearrange them back into the rows in the G Sheet?
Do you mean you want to sort the rows in the data editor? That’s a no go.
Is there a reason you don’t just sort them on the front end? It doesn’t matter in the calendar component anyway.
No, I need to write it neatly into a Google sheet, because I need to share it with other people.
I think it might be necessary to delete the entire Google sheet and then copy it back. What do you think?
Do you continue adding the rows after sharing the sheet with other people?
Sheet G. Sheet will always be updated. Once deleted I will create a whole new row including any new event insertions, after sorting by the computed column. This is just an untested idea of mine.
What about using the CSV Export option with a sorted query as the source?
Also, why can’t you just sort the data in the Google Sheet before sharing?
Too much manual effort, thank you for any suggestions.