Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

how do you reference a single cell in an external sheet...dynamically? formulas? Cell Linking?

✭✭
edited 03/01/20 in Smartsheet Basics

Thank you for your time.

I cant find the answer in the documentation or forum. So I am asking.


a. How do I reference a single cell in an external sheet?

b. Can I reference a cell by row number and column number?

c. Is there a way to make this dynamic?

using the ' =ExampleCell1 ' syntax is for the current sheet. How would I do this by for an external sheet?


Example:

  1. web-form creates a new row in Master sheet
  2. in newly created row, (column #2, row #5) then pulls text from specific cell in external sheet at (column #5, row #5)
  3. this would repeat for each new row that was created, where the row # was updated dynamically


-VLOOKUP looks for a range and a search criteria. I am not sure how to use it in this scenario as I don't have a search criteria and the range would always be changing.

-Workflow Automation requires I copy an entire row. which wont work for me.

-Cell linking doesn't seem to be able to automatically populate on newly added rows.


Thank you again.🤩

Answers

Trending in Smartsheet Basics