Add a campaign dropdown filter

As the dashboard is almost complete, the marketing director at your agency reminds you that the initial request asked for the data to be filtered by both the Source and the Campaign Name. You know that all you need to do is modify the current formula to filter for both dropdown menus.

As the formula is already quite complex at this stage, we have formatted it within the cell so that you can see the different elements of the two IF() functions. If you are struggling with the formula, you can review the relevant slide in the Slide Reference tab!

Este exercício faz parte do curso

Marketing Analytics in Google Sheets

Ver curso

Instruções do exercício

In cell H19, add another FILTER() function as an 'else' statement to the inner IF() function in the existing formula (replacing #insert your else statement here!)`.

This FILTER() function should filter the range A1:F29.
Add a REGEXMATCH() function as the first condition, which will filter B1:B29 based on the campaign dropdown H3.
Add another REGEXMATCH() function as the second condition to the FILTER() function in cell H19 to filter A1:A29 based on the source dropdown H2.

Note: Don't change the dropdown values in cells H2 and H3!

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Começar o exercício