match-rows

Drag down your formula by combining two worksheets. A step-by-step.

This directive will generate as many rows in the current worksheet as there are in the target worksheet.

📘

Important Note

The target worksheet should contain a formula and reference another worksheet

Adding 'match-rows'

Step 1: Click the "Add Directive" button on your dashboard

600600

Step 2: Choose "match-rows"

600600

Step 3: Select the worksheets you'd like to add

  • The target worksheet is the worksheet to which you'd like to add match-row to and should be the worksheet that contains formula.
  • Source worksheet is the worksheet you're pulling data from to connect to your target worksheet.
600600 600600 600600

Step 4: Once you're happy with your selection, click 'Add'

600600

Voilà, success!

Your spreadsheet will automatically take you to the target worksheet. See the results of combining those worksheets you've choosen!

600600

For more technical and in-depth information on our 'match-rows' directive, do visit our Pebble Stream Enterprise Documentation


Did this page help you?