-
Sheet Properties / Metadata - Column Count
Rows are numbered but columns are not. There should be sheet metadata available thru File / Properties that tells the user how many columns are in the sheet. This would be helpful for solution developers to know if they're approaching the 400-column limit without the tedious and error-prone task of counting them manually.…
-
Filter Columns as part of Filtering Options (not manually hide/unhide)
I would like to be able to use the "filters" feature at the top of the sheet, to filter columns, ie: "automatically hide/unhide columns", just like is available for the row filters. We use this tool as a customer facing tool and I don't want to have to manually hide/unhide the "helper" and administrative columns. By being…
-
Merged: Column Descriptions in Reports
This discussion has been merged.
-
Preserve Email Format When PopulatingMulti-Contact Columns
Description: In Smartsheet, when a Contact column (that allows multiple contacts per cell) is populated using a cell reference containing an email address, the value displayed in the target cell is automatically converted into a display name. Problem: This behavior causes a disparity between the input and output data when…
-
Fix #INVALID COLUMN VALUE error when using Index Match in a different column type than source sheet
Hello! I am curious if there is a solve to the #INVALID COLUMN VALUE error I get when trying to pull a value from another sheet using Index Match, and both the source sheet and current sheet have different column types. I am currently using the following formula: =IFERROR(INDEX({OChM - Intake - Intake Meeting Date},…
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
Column Finder
Provide a better way to find a column in sheet. For sheets with many columns, it is sometimes difficult to locate the column that you are looking for. It would be better if there were a dropdown that listed all columns in alphabetical order so that selecting it takes the focus to that column.
-
Override Column Formula
Hi, I have a column that uses a column formula to automatically calculate a date based on other columns' criteria. However, we sometimes need to manually adjust the date and override the column formula. Is there a way to do this? Thanks!
-
Copying specific columns
hello, how would i copy only selected colums to another sheet?
-
Column and Row Transpose
To whom it may concern, It would be very helpful to have a simple feature to View Columns as rows and vice versa within a sheet. A simple setting to allow the column headers to appear as rows and row information to appear on top. With the associated cell data still in the correct position. Please and thank you. Kindly, Dj