These merge fields can be applied either to to a spreadsheet that is part of a process or to static shared spreadsheet (in the library).
In the example below, 123 is the ID of the spreadsheet that is part of the process. You can find the needed IDs in the item popup when editing it. If instead you want to use a shared Spreadsheet please replace SHEET_ by SHARED_SHEET_ and use the ID of the shared Spreadsheet.
Merge Field (Copy & Paste) | Description | Result |
{SHEET_CELL_123.3:2}
or
{SHARED_SHEET_CELL_123.3:2} | Return the value of cell at row 3 and column 2 | Daviau |
{SHEET_FIRST_123.1=Anne:3}
or
{SHARED_SHEET_FIRST_123.1=Anne:3} | Find the first row where value of column 1 is "Anne". Returns the colum 3 of the found row. | 26 |
{SHEET_FIRST_123.1=Anne&2=Richardson:3}
or
{SHARED_SHEET_FIRST_123.1=Anne&2=Richardson:3} | Find the first row where value of column 1 is "Anne" and value of column 2 is "Richardson". Returns the colum 3 of the found row. | 47 |
{SHEET_SUM_123.1=Anne:3}
or
{SHARED_SHEET_SUM_123.1=Anne:3} | Find all rows where value of column 1 is "Anne" . Returns the sum of the colum 3 of the found rows. | 73 (26 + 47) |
{SHEET_LIST_123.1=Anne:3}
or
{SHARED_SHEET_LIST_123.1=Anne:3} | Find all rows where value of column 1 is "Anne" . Returns the list of the colum 3 of the found rows.
(use this to prefill dropdowns informs for instance) | "26;47" |
Keywords
CELL: returns a specific cell
LIST: returns a semicolon-separated list of cells
FIRST: returns the first cell that meets the conditions
SUM: returns the sum of cells that meets the conditions
Conditions
1=Anne | First column value equals Anne |
3=Anne,Laura,Diane | Third column value equals Anne, Laura or Diane |
_ROW=1 | Row number equals 1 |
_ROW=1,2,3 | Row number equals 1, 2 or 3 |
_ROW=_ANY | Any row (useful to get all values of a columns for instance) |
In our previous example, if you want to fill a dropdown with all the lastnames, use the following merged field : {SHEET_LIST_123._ROW=_ANY:2}
If you want to return all the lastnames excluding the title "Lastname", use the following merged field : {SHEET_LIST_123._ROW=2,3,4,5,6:2}