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?
Answers
-
I would suggest having everyone enter through the form and then you can create a report from the sheet that will auto-sort.
-
Good suggestion but in my case, the master sheet needs to be accessed for leave modifications. However, you have a good point, I am looking into creating a replica report which can be used for the view + modifications that the team will need to make. Thanks for that thought! This is getting exciting :)
-
Nice - I have a whole developer team, need to get them engaged huh
-
@Kash You should still be able to edit in the Report. I use this method pretty frequently where I have the Report for auto-sorting and editing and a form for new entries both dropped onto a dashboard for easy access.
-
Thanks Paul, that's exactly how I set it up. I like the dashboards to be the one stop solution to link back to everything internal and external that the audience needs.
Although I wish Dashboards had more enhance features. I tried synching it with Miro to embed diagrams but those come out really small and need to be clicked to view on its own platform - problem being the audience not always has access to Miro so it limits to put them as images which defeats the purpose of dynamic dashboard.
-
@Kash Happy to help. 👍️
I agree that having everything in a "one stop shop" type of dashboard makes things MUCH easier for the end user, but I also agree that Smartsheet dashboards could use some functionality upgrades. Are you using image widgets for the Miro diagrams or web content widgets?
-
I am actually using both widgets, the image at the top show a clear overview of the project, followed by a smaller web content widget at the bottom to actually go to the item and add feedback/ review data in Miro.
I could possibly use widget behavior to lead to and open the item in Miro directly but I like that web content widget which adds a bit of dynamic view.
Perhaps, I could break the images into smaller areas to show on the dashboard and then put on the dashboard to show areas of the big picture in different boxes. Still working with it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!