Just like in regular spreadsheets, filters are incredibly useful for a variety of tasks. We currently offer several filter views. To access them, click on the 'Filter' function as shown in the image below:
Next you will see an option to add a new filter, click on 'New Filter'
see below:
Next you will get to select 'WHERE' you want the filter to be implemented i.e the columns and the names that show will correspond to how your columns have been named.
For our example I selected 'Where' to be the Company Name column, and picked the filter 'Contains'
The third text box, type your customized requirements. I typed 'Aerospace' and the view changed to only show company names that contain, 'Aerospace'
To give a view as follows:
This is just an example to filter using the 'Contain' function.