-
Error: There was an error submitting the form.
I am getting an error when I submit the form. The error says " There was an error submitting the form. Please try again. If the problem continues, contact the owner of this form". I have checked the automation and all the fields with logic. They all looks fine to me and earlier everything was working. Today, when tested…
-
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…