Is it possible to filter a sheet by color (either font color or cell color)?
It is not possible to filter by those criteria themselves, but if the colors are determined by Conditional Formatting, you can filter by the same rules.
Thanks for the quick reply. My use case is not related to Conditional Formatting, so I'll submit a product enhancement request.
Hmm... Maybe in the meantime a dropdown box as a helper column (or if there are only two types, a checkbox column) for a work around. You could then filter based off of that. I know it's one more step, but at least then you'll be able to do your filtering?
Great workaround suggestion, thank you!
Having a filter by color would be very helpful. I don't see a workaround for my use case. I have a list of fees (numbers) in a column and want to identify which are secured or unsecured.
Hi,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (You can share them too, andree@getdone.se)
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I have a Smartsheet automation setup to reminder the planning to complete their sections. It is setup to remind weekly until completed box is checked. They received 2 reminders and then the reminders stopped. Any idea what could be wrong? I can't tell that anything has changed in the sheet. Thanks Freda
I'm editing formulas in a Sheet Summary. However, I'm prevented from seeing the formula by an annoying "helpful" popup that obscures my view. I can't figure out how to get rid of the popup. Does anyone know?
I am trying to create a workflow and for some reason it gives me an error with the email I entered as the recipient for my Alert. It is an email that I know works, it is shared to the sheet, and the access to the sheet is unrestricted. I am perplexed at what the issue is. Anyone else get this and know what the issue is?
