-
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. I am on an Enterprise plan yet my AI tools button is not showing. Does anyone have an explanation…
-
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…
-
Monthly Summary Report Without Daily Data
I have a report that I use to take daily numbers, and it will output a monthly summary. At this time reports are not optimized to be able to grab that data and just give me a monthly summary. I have no choice but to have that daily data in the report. I have over 26 different sets of numbers, so it fills up quickly and I…
-
How to set up an automation that is based on an if statement?
Hello! I am trying to set up an automation that changes a cell to "Complete - Pass" when four different conditions are meet. The way I am doing this is by adding and additional column that does a pretty complex if statement, and from that it either returns "Pass" or "Fail". =IF([QA Filter FAIL]@row = "Fail", "Fail",…