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

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