Yes, this is possible by using filters.
Access the filters settings from the settings menu on the add-on side-bar.
In the filter settings, you can add filters based on columns content, to:
- select rows that will generate a merge
- and /or exclude rows that will not generate a merge
Warning: Do not delete or change the first filter. This is necessary for the application to work and generate merges only once.
To add new filters, select:
- the Criteria Column: this is the column in which you want the selection of rows to happen
- the Operator and Row content: this is the condition to select or ignore the rows based on the column content.
- click the ADD button
- click the SAVE button
Warning: Do not apply 2 filters on the same column, it will not work
In the following example, we have added more filters:
If a row contains the word Sheet in column training1 AND the word Form in column training2, a document will be generated for this row.
Add your Data validation column from your spreadsheet menu: Data // Data validation.
See also: Create an in-cell drop down list