44,435 views
Data is displayed in another tab of the Google spreadsheet where the filter function is located, according to the selection of the drop-down lists of the research spreadsheet. In the example of this video lesson, when selecting an option in the drop-down list, the data that meets the search criteria is automatically displayed in the desired tab of the Google spreadsheet. To perform the automatic filter task, we use the IFS, IF and FILTER functions of Google Sheets together, to identify whether the filter should be executed with one, two or three criteria. ✅SGP Website: Sale of Collection of Ready-Made Google Spreadsheets: https://www.planilhascanalsgp.com.br/... =====================