Set up your project plan

1. In Google Sheets, highlight the cell or range of cells where you want to add a list of options.
2. Click DataData validation.
3. Click Add rule.
4. Under Criteria, select Dropdown.
5. Enter your options. 
6. (Optional) To assign color, at left, choose a color for each option.
7. (Optional) To add more options, click Add another item.
8. Click Done.

1. On your computer, open a spreadsheet in Google Sheets.
2. Select the cells you want to have checkboxes.
3. In the menu at the top, click Insert Checkbox.
4. To remove checkboxes, select the checkboxes you want to remove and press Delete.

1. On your computer, open a spreadsheet in Google Sheets.
2. To create a filter, select an option:
   • Select a range of cells, then click Data Create a filter.
   • Right click on a cell or a range of cells, then click Create a filter.
   Learn why ”Create a filter” is unavailable
   The option to “Create a filter” can be unavailable due to:

   • Formatting
     • Check for any merged cells or hidden rows or columns in the sheet. Try to unmerge the cells and unhide the rows or columns.
     • Check for any conditional formatting applied to the sheet.
       1. Go to Format.
       2. Select Conditional formatting.
          • Make sure there are no rules applied.
     • Data validation
       • Check for any data validation rules applied to the sheet.
         1. Go to Data.
         2. Select Data Validation.
            • Make sure there are no rules applied.
     • If none of the above solutions work, you might not have access. To get access:
       1. Create a copy of the sheet.
       2. Check if the filter option is enabled in the copy.
          • If it is, you can use the copy of the sheet instead.
3. To find the filter options, go to the top of the range and click Filter .
   • Filter by condition: Choose conditions or write your own custom formulas.
     Custom formula examples

     Find unique values within a data range

     • Select Custom formula is
     • Type =COUNTIF(data_range, data_range)=1

     Find text matching “Good” or “Great” within a data range

     • Select Custom formula is
     • Type =OR(REGEXMATCH(data_range, "Good"), REGEXMATCH(data_range, "Great"))
     • You can filter cells that have valid or invalid data validation rules.
   • Filter by values: To hide data points, uncheck the box next to the data point and click OK.
     • To create a filter and filter by cell value, right click on a cell then click Filter by cell value.
   • Search: Search for data points by typing in the search box.
   • Filter by color: Choose which text or fill color to filter by. You can filter by conditional formatting colors, but not alternating colors.
4. To remove the filter, select an option:
   • Click Data Remove filter.
   • Right click on any cell then click Remove filter.

Once filtered, at the bottom right users can find the number of rows being displayed out of the total rows in the table.

1. On your computer, open a spreadsheet in Google Sheets.
2. Apply the filter view .
3. Copy the URL.
4. Share the filter view link.