Is it possible to filter a column by color? We use visual management extensively for some of our larger enterprise projects and filtering by color is helpful. I didn't see a way, not sure if there was a "trick".
Have you considered using conditional formatting to create the color of your rows? You could have a column that you type the color name into to colorize it. If that was the case, you could filter on the color name and see only that color's rows. Conditional formatting could apply the color of the row based on the color name in the color field. You could even make that field a dropdown.
Just a few thoughts.
If you are using RYG(B or G) as your colors, you could still use Mike's suggestion of an additional column. You could then use a basic
=[Status Column Name]@row
to pull the text for that color into the new column and filter on that.
Instead of going through those extra steps, can't SmartSheet just develop a way to perform basic steps that Excel does such as sorting by color?
Filtering by color is now available.
I still can't see the option to filter by color. Is it in the beta testing or available to everyone?
Hi Marina,
@Marina Masterova
It will only work with the Symbols column and the Status Color options.
Did that work?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Hi Andree,
It's not clear how to highlight a row with a status color vs. one of the 40 available other colors. Sometimes it is necessary to highlight certain rows with a unique color to identify particular needs. Creating an additional column to create a new parameter to filter by in a spreadsheet with hundreds of columns is not a very helpful solution. Having the option to filter columns by text and cell highlight color would be much easier and cleaner.
Hi @Morgan Vlad-McCabe
Yes, that would be a great addition to Smartsheet features.
Please submit an Enhancement Request when you have a moment
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
This is not true
@Daniela Villamizar I just checked again, and it is still there...
Hi, I'm trying to filter at the column level (schedule status) to display only rows with red status. I'm using the same filter as demonstrated in Paul's example and it is not working. When I filter for rows yellow or green they display, but not the red. Any thoughts?
@Julie Neumann Have you made sure to scroll all the way up and that there are in fact Reds on the sheet?
@Paul Newcome yep, there are reds on the sheet. There is no way to scroll, it cuts off the rest of the sheet.
@Julie Neumann What happens if you pull a report based on the same exact criteria?
@Paul Newcome I tried that too and no luck.
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…