Gia Thinh Co.

SmartLink

Keep your source sheet and target sheets in sync

SmartLink for Smartsheet automatically updates data from a source sheet to multiple target sheets in real time, eliminating duplicate data entry and reducing the risk of typos or errors.

Keep your sheets automatically populated with data in real time

In this demo, the Employee information in your Employee Training Record sheet will be automatically populated based on employee names, eliminating the need for duplicate data entry or formulas.

Lookup and source columns in the source sheet

You can specify columns from a sheet to act as the lookup and source data, which will be copied to multiple target sheets. The Employee Name column will be used as the lookup, while the other columns will serve as source data.

Lookup and target columns in the target sheet

You can specify lookup and target columns in your sheet to be automatically updated from the source sheet. When you add a new employee training record, details like Department, Report To, Performance, and more will be populated automatically.

Lookup and target columns in the target sheet

You can specify lookup and target columns in your sheet to be automatically updated from the source sheet. When new employee rows are added to the ABC Employee List (source sheet), they will automatically be added to your Public Employee List (target sheet).

SmartLink task

The SmartLink task is created in Gia Thinh Automation Service. This task is configured with information related to the lookup/source sheet columns and the lookup/taget sheet columns.

Key features

  • Automatically updates data or cell-links data from a source sheet to multiple target sheets.
  • Option supports overwriting existing data and adding new rows to target sheets.
  • Includes a filtering option to specify which source row data is updated or added to target sheets.

How to get it:

Contact us to request a trial of SmartLink tailored to your specific needs.

We are here to assist you.