Auto Sort Smartsheet
I've seen a few threads about this already, but none seem to have an acceptable solution. My particular use case is this:
We have a Master Schedule sheet with over 100 active projects (this sheet is updated by various project managers). Every Monday morning we open this sheet and review all projects that match a particular filter I've set up. There are also various other filters that help review the projects by department, project manager, etc.
Here's the problem:
There appears to be no way to automatically sort the sheet when a new project is added, which could cause huge problems during our company wide meeting if rows are not sorted at the beginning of every meeting.
It seems everyone is recommending using a report instead of the source sheet, so the data is automatically sorted. While I could accept having to add new projects in one sheet while reviewing data in a report, I cannot accept losing the ability to then filter the data. I would have to create a separate report for each filter I currently have set up. This would be far too cumbersome, for something that could easily be done with a single Google Sheet.
I cannot understand why auto-sorting is not an option in Smartsheet, but I would love to hear any solutions you may have for this particular situation. I've tried Zapier, but I don't see a way to sort a sheet based on a trigger.