Sign in to join the conversation:
Is there a way to have a sheet auto alphabetize? I have a sheet with thousands of rows and users generally enter new rows at the bottom/next available row.
Hi,
Unfortunately, it's not possible to auto alphabetize in a sheet at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
A possible workaround could be to use a report instead.
Would that work/help?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Thanks - a report would be great for a snapshot for a team leader but the problem is that the everyday user is simply going to the bottom of the sheet, most of the time, and adding entries.
Is there a way to run an "auto sort" during a specified time or after a specific event?
Ok. Maybe it's possible to trigger the auto-sorting thru the API.
Would that be an option?
Andrée
I feel like a form/report/dashboard combo may work pretty well for this. The form would keep people from having to scroll to the bottom of so many rows, and the report would do an auto-sort.
You could use a URL widget to put the form on a dashboard and a report widget would allow for any editing that may be needed.
Everything would be on the dashboard, new entries can be made quickly, and you get the auto-sorting of the report.
Sure! I think so! Can you advise on how to set up and I will try it?
Excellent!
This might help!
https://smartsheet-platform.github.io/api-docs/#sort-rows-in-sheet
Thanks! Were would I put this code in order to auto sort?
Happy to help!
You must program with the help of the Smartsheet API so it's not done inside of Smartsheet.
Start here: http://developers.smartsheet.com/
Hope that helps!
I created a new sheet for my team by replicating an older sheet and now my tasks aren't pulling into my task report or any of my teammates. I confirmed the sheet was selected in my report but it still isn't pulling in. I've never had an issue with this before so would love some advice on troubleshooting.
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks
Hi Everyone, I created some forms for our powdercoat test logs. The forms are working great for the employees to input the data. The problem I am having is with giving the supervisors and managers access to the sheet. I gave them Editor Cannot Share permissions to see and edit the sheet. But they are saying that Smartsheet…
