-
Auto Sort
Hello, Is there any way to create automation that will automatically sort a sheet when a cell is updated or changed? Thank you, Sean
-
Automated Sort in Sheet
Is it possible to create an automation that sorts the rows automatically when changes are saved? For example, if my sheet is sorted by Column "Stage" Numerically Increasing, and I insert a row, fill it in, and save it, I want the sheet to re-sort to incorporate that added row in its proper location. Thank you!
-
Sorting and Filtering
Hello, I have users who are wanting to sort their filtered view without impacting the data structure. I've seen in a couple threads now that the workaround is to build a report, but non-licensed users are not able to filter and sort within the report I made - so there's really no point to the report now. Does anyone have…
-
How do I write this formula?
I want to write a formula that calculates the number of days we have from today until we run out of stock. I have: The number of Laptops Available The Avg Monthly Hires and I know we give out laptops at NEO every other Monday (Next one in February 17, then March 3rd, March 17th so on) How can we tell the number of days…
-
Batch Editing
I would love to be able to select multiple tasks on a sheet and change the status if they are all the same. This could affect dropdown columns and date columns.
-
Any way to update formula criteria with drag-fill
Hello, I have a sheet with around 3000 rows all of which have a date received and I am trying to count how many were received per week. Currently I have a helper column which has the week number (1-52) and have =COUNTIF([Week number]@Row, =1) which works but I am wondering how to then extend the formula to automatically…
-
Primary Columns in Grouped Reports: change label locations and move column
A report must use a sheet’s primary column and the primary column must be in the first report column. Labels for report groups are displayed in the report’s primary column, so if you don’t want to view the primary column in the report, or hide the primary column, then the groups’ labels will be hidden. If you copy the rows…
-
AI Tools Button Disappeared on Enterprise Plan
Hello Smartsheet Community, While I understand that Smartsheet rolled out AI tools for ALL accounts for a period of time that has now come to an end, Smartsheet's post (linked) says it should be available for Enterprise plans. https://help.smartsheet.com/2483096/AI-Formulas-text-generator I am on an Enterprise plan yet my…
-
How do I hide the sidebar/shared with bar?
Is there anyway to hide the left sidebar or workspace shared to bar in this new update? I can't see the names of anything unless I zoom out from the entire window.
-
Contact list in Smartsheet after importing data
I am running into an issue where I import a group of names assigned to a certain task in Smartsheet. The list of names comes from an excel spreadsheet as multiple agencies must provide their inputs and not all have Smartsheet access (the Smartsheet in question is only for my agency's use). Well after importing the updated…