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.

cell linking

Rudy Landry Jr

Rudy Landry Jr ✭

05/28/15 edited 12/09/19 in Archived 2015 Posts

Is there anyway to cell link in templates? or Template to sheet? or just sheet to sheet? trying to keep annual running records for monthly reports?

Tags:

Cell linking

0 ·

Comments

JamesR ✭✭✭✭✭✭

05/29/15

You can only link cells Sheet to sheet(s).
Not sure why the templates?
If you save as a sheet that has the links in then the links will carry over into the new sheet.

0 · Share on Facebook Share on Twitter
Travis Employee

05/29/15

Here's information on cell linking in Smartsheet: http://help.smartsheet.com/customer/portal/articles/861579-cell-linking

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Date Completed triggers Check Box
I want my user to enter the Completed date and the Check box in the Completed column gets checked. I know this is simple, and I have found answers for the other way, but I want it set this way.
I am trying us an IF statement to populate text in a cell, based off value in previous cell.
=IF(RPN@row > "400", "HIGH", IF(RPN@row < "150", "LOW", "MEDIUM")) Based off the values, the text does not always populate correctly. Example - a value of 5 will come back as "HIGH". A value of 25 shows "MEDIUM". A value of 125 shows "LOW".
IFERROR and OR
I have these two formulas in different columns: =IFERROR(INDEX({Frame ECN Updates Range 2}, MATCH([ECN / PLR / FF / CEG]@row, {Frame ECN Updates Range 1}, 0)), "") =(IFERROR(INDEX({Frame Feedback Updates Range 1}, MATCH([ECN / PLR / FF / CEG]@row, {Frame Feedback Updates Range 3}, 0)), "")) Individually, they each output…