-
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…
-
Merged: Override Column Formula for Particular Cells
This discussion has been merged.
-
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…
-
Hide Unhide Columns
Hi @Genevieve P., @MMcLain, Last time I checked the Community Discussions on the subject of "hide unhide" under the categories of Smartsheet Basics or Product Feedback there were 1,076 posts about the subject going back over more than 5 years. It seems like some product improvements need to be delivered in this area! While…
-
Ability to Change Column Type When Conditional Formatting Exists
I would like to be able to change column types without having to delete conditional formatting rules. Currently I have 20 columns that I want to change from Text/Number to Dropdown List. They each have 5 Conditional Formatting rules applied to them. I can't change the column types without deleting the rules first. I can…
-
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…
-
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…
-
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.
-
Merged: Select columns feature in "Move a row" automation
This discussion has been merged.