-
Sort Rows with criteria
It would be great if you could use the Sort Row function with a criteria option also. For Example: If I had a range of open and closed requests that have different due dates. Sort rows by "Due Date" with due soonest showing at the top but only the rows where the closed box has not been ticked, the rows that are "closed"…
-
Auto Sort sheet using API - Python
I have a code that should work to auto-sort my sheet, but I keep getting the message below. Others have used this script with no problem. Any advice would be greatly appreciated. Error sorting sheet. Status code: 405 "errorCode" : 1122, "message" : "Requested URL does not support this method: PUT", Here is the script I…
-
Auto-sort using API
I understand that as of now it is not possible to auto-sort columns in Smartsheet. But is there an API code that can be used to sort columns alphabetically?
-
Filter comments that include my name
How can I filter or sort comments so I only see the ones with @myname? My team asks tons of questions via smartsheets (one giant sheet with hundreds of entries) and it is very hard to keep up with all the comments and make sure we don't miss anything. The email notification with link to the link isn't enough. I want each…
-
Shared Permissions, sort?
Hi Smartsheet, I think the Shared pop up has changed slightly in the past 3-5 months. How can I sort the Shared users by permission set? I need to reach out to just the group of admins of a specific sheet. Thanks!
-
Admins: How do you keep everything ORGANIZED?
We're a city government with a couple hundred users using Smartsheet right now and I'm having a hard time keeping track of all the files that are out there. We're about to roll-out to 1,500 users so the mess will multiply by at least 7. The mess I can't keep up with is: Workspaces: There's no way to filter the list, tag…
-
How to sort by the summary count in my row report from Highest to Lowest?
-
Rolling 12 month column chart
I have a column chart as seen below: The summary sheet i use as the data source is formatted as below: I used a summary sheet instead of a summary report as it gives me more options to manipulate the data, but also structure it correctly in terms of month order. The months and years will have to manually be inputted and…
-
Merged: Smartsheet reports, sorting by more than three sorting rules
This discussion has been merged.
-
Possible to Undo Sorting from a Day Ago?
Hello all, A colleague asked me for help with something in Smartsheet I could not solve so I wanted to ask for the community's thoughts! A collaborator sorted a sheet based on a particular column (in error) and were unable to undo it. This is the next day and I did not see any way to undo (additionally, there were no other…