Filtering columns by Color

Using either conditional formatting or manually selecting a background color for a cell, it would be great if we could then sort or filter a column by a specific color. There could be numerous use cases for this including "highlighting changes made to a specific column that we want to filter on instead of using the "Highlight Changes" button which shows "ALL" changes in the sheet."

Sign in to vote!

Find more posts tagged with

Idea Submitted

Filters

Comments

MaggieM

I miss this feature so very much in Smartsheet. I find myself taking data to google sheet or excel just to do this (which ruins my efficiency!)

CP_LAW

I 100% agree. Filtering by color would up my game immensely. I use a lot of color to keep track of statuses in large grids. Filtering by color would allow me to use color more and sort quickly.

TWC_HB05

I'm with the group on this one. I use the cell colors to quickly see info and it would be nice to filter by particular color(s)

alyssad

I have conditional formatting that will colour-code cells based on specific dates and cannot filter or sort my sheet by cell colour.

Abbey H.

I would like to be able to filter rows by a color of fill certain cells have. Often I'll set up a flag and used that to apply a conditional formatting to a cell. For example, if a cost over time increase, it gets flagged as red. I'd like to be able to sort out all "red" rows.

I'm sure this has been suggested before; however I do not see it and feel like it would be basic to implement.

Kim V

I use conditional formatting on long task lists to highlight tasks that are due in the next x number of days. The ability to then filter based on the cell color will support my need for efficiency.

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Editable email Subject header from Smartsheet Notification
Hi There, I would like to propose that Smartsheet considers the email subject header that is received from a Smartsheet notification from a form or sheet. Currently, because not everyone in my company has Smartsheet, let alone a Smartsheet log-in, we need to send show the name of the owner of the sheet, that appears on the…