Filter over multiple columns with AND and OR
Hello,
I've a question using the filter within a smartsheet.
As an example with filtering over 3 columns A B C:
(A contains "aaa" OR B contains "aaa") AND C = "123"
Combination of "OR" bewtween two colums and "AND" to the third column seem not to be practible.
Any idea?
Thanks Kay
Best Answer
-
Hi @KROnline,
The filters only appear to have either meeting one of the conditions, or meeting them all.
However, you can get round this with a helper column.
This would have the formula:
=JOIN(A@row:B@row, " ")
So for some data you'd get something like this:
Your filter would then be:
To get results:
Hope this helps!
Answers
-
Hi @KROnline,
The filters only appear to have either meeting one of the conditions, or meeting them all.
However, you can get round this with a helper column.
This would have the formula:
=JOIN(A@row:B@row, " ")
So for some data you'd get something like this:
Your filter would then be:
To get results:
Hope this helps!
-
Hi @Nick Korna ,
thanks for that - good workarround.
But regarding complex sheets with complex filters Smartsheet should make some improvements within the tool.
Best Kay
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives