-
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…
-
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
-
Source Sheet & Dynamic View Dates Don't Match
I'm building a dynamic view and have pulled in the date column and it doesn't match my source sheet. Source sheet used a column type of "Created Date" and displays as 03/15/23 1:19 PM. Dynamic View shows as 2023-03-06T21:38:58Z. Is there a way to show the date in my dynamic view similar to what the sheet shows?