Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Reference a value from 1 sheet in a formula

Options
kbrady13766
edited 12/09/19 in Archived 2017 Posts

Is there a way to reference a specific value from one sheet into a formula on a different sheet.

For example Sheet 1 Row 1 Column 1 has a value of 5

Sheet 2 would like to reference Sheet 1, row 1, column 1 in a simple SUM formula

=SUM(Sheet1:Row1Column1+Sheet2:Row5Column3)

If Sheet 1 Row 1 Column 1 has a value of 5 and Sheet 2 Row 5 Column 3 has a 10 as the value then 5+10=15 would display where the formula was entered on sheet 2

Tags:

Comments

This discussion has been closed.