Automatic sorting of a column - workflow?
Hi, just wondering if anyone set up a workflow to automatically sort a column by date every time it loads.
I have a sheet with calendar dates, where team is entering time off. Then there is a form which also captures time off and populates into this sheet. Instead of the entries going to the relevant date row, they are going at the bottom of the sheet after a few empty rows. Which forces me to sort it by date every time to get them back up in chronological order.
Any work around this?
Help Article Resources
Check out the Formula Handbook template!