Filter Rows to Display Only Yes in Excel or Google Sheets

·

I have a column with "Yes", "No" and "unknown" in it. I want the next column to only show the "rows that have "Yes" in them. How can I do this?

· Sorted by Oldest

Clay
APP
·
·
You can use filters to display only rows with "Yes" values: 1. Click the Filters button at the top of your table 2. Click + Add filter 3. Select your column containing "Yes/No/unknown" values 4. Choose equal to as the comparison operator 5. Enter "Yes" as the value Alternatively, you can create a new formula column: 1. Click Add Column > Formula 2. Use "/" to reference your original column in the AI Formula Generator 3. Type something like "Show data only if /[column_name] equals Yes" 4. Click Generate Formula and Save Formula
Sources: Customize your table view | Documentation | Clay University Hide, Re-order, Sort, Filter, Merge Columns Formulas
LuisArturo
·
·
Hey there Jelle thanks for reaching out, sorry for the delay, you can do this by using a formula column to tell the table that you only want a specific value to appear in a column. For example using a formula such as "Return the value inside of /(column name) if the value is equal to "Yes"
1

Clay
APP
·
·
You can use filters to display only rows with "Yes" values: 1. Click the Filters button at the top of your table 2. Click + Add filter 3. Select your column containing "Yes/No/unknown" values 4. Choose equal to as the comparison operator 5. Enter "Yes" as the value Alternatively, you can create a new formula column: 1. Click Add Column > Formula 2. Use "/" to reference your original column in the AI Formula Generator 3. Type something like "Show data only if /[column_name] equals Yes" 4. Click Generate Formula and Save Formula
Sources: Customize your table view | Documentation | Clay University Hide, Re-order, Sort, Filter, Merge Columns Formulas
LuisArturo
·
·
Hey there Jelle thanks for reaching out, sorry for the delay, you can do this by using a formula column to tell the table that you only want a specific value to appear in a column. For example using a formula such as "Return the value inside of /(column name) if the value is equal to "Yes"
1