Filter a column to add all of a key word to the bottom

shayden1

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?

Jeff Reisman

@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", "")

Jeff Reisman

@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", "")

shayden1

@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!

Jeff Reisman

@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.

shayden1

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.

Jeff Reisman

@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", "")