-
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!
-
Can't compare two string values
So I'm using this formula to try and compare two "String" values. In this situation, some values in Column 2/3 will be numerical only and some will have text. I have a helper column checking that both are string values but it still won't match. I've tried with collect and contains too. I'm trying to pull the value in…
-
Best Way to Pull A Ton of Data
Hello Community, I have recently been given the challenge of pulling a ton of data from a source sheet to a target sheet, and am trying to figure out the best way to pull all the data efficiently and not run out of space too quick. Unfortunately we cannot use data mesh because each row has 7 target columns to pull from.…
-
% Complete showing 10,000% instead of 100%
Hi, I noticed few week ago that when I enter 100 in my %Complete column it shows 10,000% as value. It looks like it add zero to my entered number. Does anyone know how I can change the setting back to what it used to be meaning if I enter 100% it shows 100%. Regards, Audrey
