top of page

How to connect multiple data sources in Smartsheet

Updated: Jul 28, 2022



There are two ways to connect multiple data sources in Smartsheet.

  1. Vlookup

  2. Index Match


1. VLOOKUP


This is an advanced Smartsheet function that looks up a value and returns a value from a different column in the corresponding row.


Syntax - VLOOKUP( search_value, lookup_table, column_num, [match_type ])


For example – In the sheet shown in the picture, if you want to look for an employee’s joining date based on the name, use the following formula –


=VLOOKUP([Metric / Search Value]@row, [Employee Name