Automation to Sort Sheet at Predetermined Time

Jesse Hart

Good Day Smart Sheets community,

I have a few automation notifications that are ran each Monday Morning at 6AM based off of an Est. Install Date column. I would like the rows to be listed in chronological order from top to bottom in the notification email. It seems the only way to do this is to have the sheet sorted in that order before the automation takes place. Is there an automation that could be scheduled to do this right before the notification automation happens every week? Multiple people use our master sheet and sort it by various columns throughout the week. The only other thing I can think of is to set a personal reminder on my phone to myself to sort the sheet the way I want it the night before the notification automation takes place. Any ideas?

Paul Newcome

There is currently no way to "auto-sort" a sheet whether that be a default sort or automation. You could create a report and have the report set up to send on a schedule, and the report does auto-sort.