Can I filter by columns, not rows?
Hi. I'd like to filter a Smartsheet like this…
… show only rows where (<column4> is checked OR <column8> is checked)
Is this possible? I can only see filtering by row values, not column values.
It is not practical for me to transpose the Smartsheet because the primary column has long text and contains over 100 rows.
Answers
-
Yes, you would be able to set a filter for Show rows that match - cchange that from all conditions to at least one.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
Thank you. I realise I've not explained this properly at all, sorry.
I want to see only the columns where a particular row is checked.
I have about 20 columns and am adding new ones each week, so doing this line by line will soon get unwieldy.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!