-
Contact type column across multiple sheets
I have a list of contractors that is constantly being updated, from when they are on-boarded, to when they are deactivated. I would like them to be entered as a contact type column. I have multiple sheets where I want this column to be identicle, and also want that when I update Sheet A and add a new contractor and their…
-
Dependant dropdown lists
Hi. Is it possible to create a dorpdown list that is dependent on the option selected in other column. For example, when I have list of 300 Banks with SWIFT codes . One column is Bank name, another column is SWIFT code. I also have a list of vendors and need to choose in vendor form their bank account. I write vendor name…
-
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.)?
-
Merged: Unhide a single or range of hidden columns
This discussion has been merged.
-
Help on Or/Contains formula
I am in the need of some help as I am banging my head against the wall trying different formula options here. I wish to grab all characters left of a certain character combination (" -") from a drop-down cell. For instance, I wish to grab "Hosted Event (physical)" from the drop-down cell with "Hosted Event (physical) -…
-
Merged: Auto sort rows in sheet
This discussion has been merged.
-
Linking Two Sheets to update dynamically When columns are added and removed.
I have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5 I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were to add in a row between two and three with a value of 2.5, I would like this to update on…
-
Better filter function
Can a better and more flexible filter function designed for the sheet. Currently it is taking a long time to create a function compared to how excel is like which allows you to have different combo of filter to each column by only clicking the header of the column. Can this be in the smartsheet please? Thanks.
-
Freeze pane on selected columns
Is there a functionality where selected columns (let say column 1 then 5 then 8) can be frozen instead of the whole consecutive columns? This functionality would be good for a sheet which contains a long list of columns.
-
Column Filtering for Sheets
Enhancement Request: Filters on sheets are a wonderful addition to Smartsheet. Since they were introduced, we have learned to rely on them more and more. One enhancement we would like to see is the ability to filter columns in addition to rows. Please add my vote for this feature. Thanks!
