-
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…
-
Workspace tags or formatting
I would like to be able to sort or tag or otherwise format my workspaces in the browse view. I've got several different projects going on and it would be helpful to my brain to visually sort them. Something like this: Or perhaps create higher level Workspaces to better sort projects? Just an idea. Thanks for considering.
-
Does sorting not stick?
I have a sheet that is a recipient of a 'Copy Row' automation when criteria on a different sheet is met. In the recipient sheet, we have it sorted in a particular manner but it seems to break all the time and just shuffle the rows around. From what I can tell, it is in no particular order either. We were assuming that the…
-
Sort a column by Max number value
Hi there, I'm hoping someone could help me, I am trying to sort a column by its highest numerical value but sorting ascending is not outputting as I expected, hopefully someone may be able to direct me to the best way to do this: I am trying to sort by Total FY Spend, yet when I sort ascending: It shows the top value, then…
-
Default Sorting
I would love to have either: A way to save a particular sort, so that if I add rows via forms I can click a button and sort all my rows with a default sort (rather than go through the process of sorting by three different columns every single time I need to sort my sheet An option to enter the row in chronological order by…
-
Sort Attachments, more options.
It would be really useful to sort all attachments by file types. I have a sheet with over 1000 rows that users upload PDFs, Excel, and photos to in each line and I'm in need to find only the excel attachments for the whole sheet. There is, as far as I can tell, no way to cull file types.
-
Can I filter or sort by highlighted changes?
I have a project tracker sheet that is set up so that we can import a file from our customer regularly that updates existing worksites, and adds new ones to our tracker sheet. We are able to use "Highlight changes" to easily see what cells are updated and what rows are added. What we would like to be able to do, either in…
-
Assigning Individuals into groups based on qualification and group
I have a bulk list of 2000+ names along with their certification/qualification and affiliated group. I need to come up with an automated way of assigning each of these people into 40 groups. Each group must have a minimum of X numbers of each qualification (ex. Group 1 must have a 2 plumbers, 2 scientists and 10 fisherman,…
