Conditional Logic for Data Merges
How to use conditional logic to set the Data Merge to only operate on certain rows
Last updated
Was this helpful?
How to use conditional logic to set the Data Merge to only operate on certain rows
Last updated
Was this helpful?
Conditional logic is a great setting if you want to create documents only from certain rows within a spreadsheet. It can be selected from the dropdown list within the Data Merge box.
In this article you’ll learn how to:
Set up a condition
Advanced settings for conditions
If you would like to set up a condition for a data merge, all you need to do is go to the Data Merge box and select 'condition' in the drop down menu.
After you have selected condition, the next step is to select the field the condition is based on. Open the next drop down menu and select the field. If the field you want is not there you might have to click refresh in the the top right hand corner on the data sources table.
After that enter the value the field has to equal for the automation to run and bam! You're done :)
It is possible to add a more advance filter that is based on two conditions (or a different operator other than 'equal') by adding another column to your spreadsheet. In this new column you can add a formula that contains the advanced conditions and then use the result of this column for the data merge. For example you could use formulae like these:
Returns 'Merge' when two different words (Apple & Orange) are entered in two seperate columns (Column A & Column B): =IF(AND(A4="Apple",B4="Orange"),"Merge","")
Returns 'Merge' when either word (Apple or Orange) is entered in one column (Column A): =IFERROR(IFS(A2="Apple", "Merge", A2="Orange", "Merge"),"")
Then you could set the condition in Portant to Merge based on when this column equals 'Merge'.
Thanks,
Blake and James
This is quite a good guide on using 'IF' & 'AND' functions together:
We created Portant in 2021 and the feedback we have received since then has been very helpful and greatly appreciated. If you have any feedback please feel free to send us an email at
