-
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
-
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?
-
Omit records with No data on Charts
I have a Workspace with a form that feeds into a sheet Then I have a calculations sheet that adds up everything (most of which us SUMIF). Now a few of these Workstreams (which are in a dropdown list on my form/main sheet do NOT have any data currently associated with them. But that will change. And like I said these…
-
therapy caseload/client data tracking... anyone have success with smartsheet?
Hi all, I'm an Occupational therapist for kids with autism. After the pandemic rendered our therapy office paper data filing system obsolete(I couldn't access it from home), I determined to make the move to digital client records Smart sheet seemed like a user friendly option over excel I'm looking for a basic set up that…
