-
Make Hiding & Unhiding columns an Automation function
Perhaps my "search foo" is a bit rusty, but I could not find an existing suggestion for this specific issue, only several tangentially related suggestions. I believe this is pretty self-explanatory. I have sheets with several checkbox columns that are typically hidden, but often need to be unhidden to perform some action.…
-
Unhide all columns
I need to be able to unhide one single column. NOT ALL. Is there a feature where I can pick the column I need to view. We have weekly columns that go back 2 plus years. I do not need to see over 100 columns unhidden. The unhide all feature is not useful to our business.
-
Is it possible to get rows automatically sorted in a sheet as new rows are added?
I have several sheets where it would be incredibly useful for them to automatically sort as new rows get added & cells change. Is there a workflow I can set up to do this so it automatically sorts on some kind of timeline (daily, weekly, etc.)?
-
Default Sort setting
Hi, How can I set a default for sorting in a sheet? For example, I have a system "Modified Date" column, and I want the sheet to ALWAYS sort by descending order, i.e. the most recently modified on top. I want the sort setting to stay even when refreshed, and when I'm editing in the sheet that the modified row will…
-
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!
-
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…
-
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…
-
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…