How to connect multiple data sources in Smartsheet
Updated: Jul 28, 2022

There are two ways to connect multiple data sources in Smartsheet.
Vlookup
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