Automation to Sort Sheet at Predetermined Time
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?
Help Article Resources
Check out the Formula Handbook template!