-
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!
-
Auto sort
Checking if there's been any movement on having the sheets sort by data in a column as I see it's been requested since at least 2016. We have sheets that are sorted by a date that could be 2 days from the day entered or 12 months from the day entered. We also have a filter to hide past dates. Data is being entered via form…
-
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
-
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…
-
Is anyone using a "ai service" for meeting notes and importing into smartsheet?
Hello - we track client meeting notes for our projects in a smartsheet. We use a parent-child relationship for the meeting titles, and the children are all of the topics. We track open and closed items with assigned to and dates. We might have 20 meetings for a client. It works pretty well. We are recording the meetings…
-
Trying to pull data from one sheet to another
I'm trying to get the most recent submission of a form (about vehicles) to pull the most recent mileage to our master vehicle sheet. I have tried several things, and I can't figure it out. =(JOIN(COLLECT({Most Recent Vehicles Check in/out Range 4}, {Most Recent Vehicles Check in/out Range 3}, HAS([ASSET#]@row,@row)),"-") I…
-
Add 'sort order' to Filter Views
I love the Filter Views feature in Smartsheet, but it would be really useful to include Sorting options in the Filter View dialog as well. Some of my filter views require sorting by different columns, and currently it's a bit annoying have to manual sort each time I change a view.
-
Merge cell functions
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
-
Can Created By Column be Wrong?
One of my users reached out because they received a notification in which they are ID'd as the creator of the project request, which they claim to not be. I checked the source sheet and they are indeed listed in the "Created By" column with a date about 1 month ago. You have to log in to enter requests in my form and I…
-
Include Column Origin in Properties
This request stems from my copying and moving rows from sheet to sheet. It would be very helpful for me to click on a column and see where the column originated from (Sheet name). If it was copied/moved and carried over from a different sheet, or if it was created within the current sheet. I'm running into very frustrating…