I have a spreadsheet where my data depends on multiple checkboxes (each checkbox represent a country : for example if i tick the Spain checkbox, the data shown will be related only to Spain). Now I have to create one spreadsheet for each country with formulas calling to the original spreadsheet, and so I want my new spreadsheet to call only the data of its related country (for example the "Spain" sheet would consider that only the "Spain" checkbox is ticked in the original spreadsheet).
I have tried using IF or other condition related function or Data manipulation but nothing gave me satisfactory results.
Thank you for your help.