...
Mapping Tips: To map a group of cells from a Google Sheets table, use the name of the sheet followed by an exclamation mark, the column of the top left cell, its row, a colon, the row of the bottom right cell, and its column. Example: Sheet3!B3:D10.
All rows in one column: Sheet3!B:B (use the column name twice and omit the row numbers).
All rows in multiple adjacent columns: Sheet3!B:D (use the names of the first and last column in the range and omit the row numbers).
All columns in multiple adjacent rows: Sheet3!2:10 (use the numbers of the first and last row in the range and omit the column names).
Related Pages
v2023.07 ✅