-
Column filter not showing results
Hello! I am trying to filter for multiple items in a single column. The screenshot below illustrates the fields I am entering but when I apply it comes back with zero results. The value entered is the exact language as it appears in the cell. What am I doing wrong? Can anyone assist? Thanks!! Adding - Can you filter…
-
Add Quick Filters on Column Headers in Reports (like Excel)
It would be very helpful if Smartsheet allowed quick filters directly on column headers, similar to Excel. Right now, creating a filter requires multiple steps and saving it, which takes extra time for simple tasks. Having the ability to quickly filter a column by value, number, or condition (directly from the header…
-
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…
-
New column type: Currency-only
I see there’s already an idea requesting a "Number only" column type, and I’d like to suggest adding a "Currency only" column type as well. Currently, I have to create several workarounds to validate certain fields we collect. For example: Ticket number or Purchase Order number fields should only allow numbers and have a…
-
Columns have reordered
I have a question about Smartsheet. I have columns in my sheet for Monday, Tuesday, etc. Somehow, Monday moved to the end of the sheet. So, now Monday is after Sunday. I looked at the activity log, and it shows that the columns were reordered. How can I get them back to the beginning of the sheet, other than by dragging…
-
Default Column Sort Priority
is the ability to create a permanent default sort on a column (status) a feature request that is in the works or that will soon be implemented? having to create a helper column seems more like a work around instead of a solution. How this isn't a feature already when you already have sooo many amazing features is beyond me.
-
Synchronize Column Description, Input Form Help Text, and Dynamic View Description/Help Text
Allow for synchronization/harmonization of Column Description and Help Text fields across Smartsheet assets. The Column Description in Sheet view could be the default source of Help Text for that same Column in any Input Forms based on that Sheet, as well as the Description/Help Text for that Column in any related Dynamic…
-
Formula Range
Hello Community, Is there a way to make the range for a formula start at a certain row and then continue on once other rows are created? I've found that leaving the end of range number blank or putting a future number row that has not been created causes the formula to be Unparseable.
-
Board View no Names of Columns
Dear Community, I noticed that in the BoardView or CardView the names of the columns are not visible which make our cards very unreadable… is this on purpose or I am missing something? Those blue dots are symbols columns but now useless without the Name of what they represent.
-
Mode Function
A formula for the Mode of a column would be helpful. I have gotten help from the community members on alternatives with helper columns and have found methods online but having a set function would make the process more efficient.
-
Mode Function
Does anyone know if there is a "Mode" formula yet without using a helper column?
-
Cross sheet functioning column formulas working perfectly...except for two rows?
Problem Summary: I have a series of formulas and cross sheet references which grab display data that meet certain conditions. They are working consistently across usage…except for two rows? For data sensitivity, I'll only be including the date fields out of the display data, but the same error applies to all final display…
-
List of Automations that include a Specific Column
We have multiple automated workflows that may utilize a single column. Currently, the only way to know if a column is used in a workflow is either in the workflow builder view or when you attempt to delete a column used in a workflow. It would be awesome to see a list of all automated workflows that are currently utilizing…
-
Best practice to apply formula to columns
Hey y'all. I often catch myself stuck on applying a formula to a whole column. Is there a best practice or more effective way to apply formulas?
-
Export Column Properties
I would like to be able to export the column properties of a sheet. It would be incredibly beneficial to be able to export the extensive structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only…
-
Export Column Properties
Is there a way to export the column properties of a sheet ? It would be incredibly beneficial to be able to export the structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only Add contacts…
-
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.…
-
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},…
-
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…