Linking to other cells

Hey,

So we have 2 sheets. New Projects sheet and Tasks sheet.

The New Projects one have 2 column. ID and name of the project, whenever we get a new project we insert the name and ID manually.

I want the Tasks sheet to have those column as well (ID and name) and I want it to be dynamic. Meaning we add on Projects sheet, it automatically appear in the Tasks sheet.

On excel, i'll just use: ='NewProject'!A1 and 'NewProject'!B1

and then just 'stretch' the formula down, so whenever I add something in NewProject, it will be added to Tasks, and if there's nothing, it will just stay blank.

So in excel i would get:

='NewProject'!A1

='NewProject'!A2

='NewProject'!A3

='NewProject'!A4

etc.

But here, it seems like I can't stretch the formula no matter what... How can I do it?

Thanks!

Find more posts tagged with

Sheets

Support

Cell linking

Account and User Management

Comments

L_123

That was a lot more painful than I would have thought.

https://app.smartsheet.com/b/publish?EQBCT=bc2e2e96b8d24e0db4ad50993a744256

I would avoid this solution if you plan on having a several thousand row sheet as it will slow down in a hurry with all the text parsing.

basically what I did was pull the entire column from one sheet into a join function in another sheet, and used the delimiter with an ~ to separate the values. I then used text parsing to sort the values and post them into the appropriate cells in the column in the new sheet.

If you want you can play with the count function and post without the ~ in the original row, I was about done with this so i just made it a helper column and posted the pretty version in the column beside it.

Jim Hook

I may be wrong but I don't see why simple linking from the first sheet to the second sheet wouldn't work for you. The second sheet can have as many as 5000 incoming cell links if that's enough for you. The only problem with using links is that if you want to get rid of a completed project you can't simply delete the rows on the first sheet without destroying the links to the second sheet. Also, keeping the second sheet projects in the same order if you move some rows up or down in the first sheet (like when you start a new project) won't automatically reorder the projects on the second sheet. That might need to be done using drag and drop rows on both sheets. I do things like that a lot and just reorder sheets as needed.

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…