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

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


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



This discussion has been closed.