Filter Tasks by Cell Value

1. Select a cell in the spreadsheet for the field with the value you want to filter on, e.g. select the Metres cell for a task with value of 30.
2. Select one of the following options:
   • Press the Filter on cell valuebutton in the Advanced Filter section on the Data page of the ribbon bar.
3. DTS will automatically build a filter based on the field and value of the selected cell.
4. You can add conditions to the filter by selecting other cells and clicking the Filter on cell value button again.