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
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