Filter a column to add all of a key word to the bottom
I am wondering if there is a way to filter on a keyword in a column, and move all rows containing that to the bottom of the Smartsheet. Another option would be if I am able to sort so all rows highlighted a certain color drop to the bottom?
Best Answer
-
@shayden1 I would use a helper column (which you can hide) that utilizes the CONTAINS function to search for the keyword, and set a value in the helper column on rows that match. Then use Sort to keep those at the bottom. Something like this:
=IF(CONTAINS("Jeff is awesome", KeywordColumn@row), "True", "")
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
@shayden1 I would use a helper column (which you can hide) that utilizes the CONTAINS function to search for the keyword, and set a value in the helper column on rows that match. Then use Sort to keep those at the bottom. Something like this:
=IF(CONTAINS("Jeff is awesome", KeywordColumn@row), "True", "")
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
@Jeff Reisman This appears that it would work, but I am having troubles getting it to work. Can you maybe share a screenshot of this formula in a sheet or more details on how to build it out. I am still learning on Smartsheet.
Thank you!
-
@shayden1 What is the column type of the keyword column? What type of keyword are you looking for? Are you getting an error message? If so, what is the error message?
The CONTAINS function looks for an exact string match within a text/number column, single or multi-select drop down columns, or contact/multi-contact columns. However, depending on what is in the text string and what column type it is, another function such as HAS may be better suited for this task.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
The column is set up as a text/number and the text I am looking for is "Parking Lot" in a column titled "Type". The extra column I created is also a text/number and is titled "Extra". I could also sort based off a color of a row if that is possible.
-
@shayden1 Could you share the formula you are trying, and any error message you get?
This is from a test sheet: =IF(CONTAINS("Yeah No Way", [Column142]@row), "True", "")
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 361 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives