Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I am trying to get a sheet to link into another however we want to be able to use the sheet over and over again and have it where it will link in new rows.
Is there a way to do this?
Please Help
Thanks
Hi Justin,
You'll need to use a formula with a cross-sheet reference instead of a cell link.
Depending on how the source sheet is structured and the information contained (e.g. are there a fixed number of rows/cells or will new rows be continually added to this sheet as well) will determine the way you go about this.
Could you please tell us a little more about what your sheets look like?
Kind regards,
Chris McKay
I have attached two files for you to assist me with. I would like the Project Check in sheet to be the sheet we keep using over and over again. The Project Information Sheet is the sheet I would like to use as the master.
I also would like to use the Project Check in sheet as a URL link from another sheet and then link it to the project information sheet as well.
I have attached a copy of where I would like to use the URL Link as well for the Project Check in form for each project.
Chris,
Is there anything I can do for the information I provided above?
So just to be clear (as you've not clearly included the sheet names in both images):
Assuming this, is the following what you're looking to achieve:
If this is correct, you will first need to add a unique identifier column into the Project Information sheet. Essentially a Project Code. This will ensure that you only one possible row can exist for each project. This would prevent issues with the one Contract Holder (Firm Name) having more than one contract. Maybe use an Autonumber column?
So if I'm on the right track, you'd want to do the following in your Project Check-in sheet template:
When I put the following formula in to the project check in sheet because that is where I would like all the information to go into from the Project Information Sheet I am getting an INVALID REF
Here is the formula:
=INDEX({Project Information Sheet Range 1}, MATCH([Project Code]1, {{Project Information Sheet Range 2}))
Chris
I actually got it working now. I do have one more question. Will the cross reference information work if we fill out a form rather than a sheet?
Glad to hear you got things working. Yes a sheet that is populated via a form will still work.
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
When i try to send or print the timeline view instead of showing the progression bars like they do on the screen it only send the data entered and not a graph type view to print. Is there a way to do this. I am using a mac platform if that helps.
Please assist me, I am having trouble with my smartsheet, I am on a paid pro plan, with 5 paid members, but neither I or my members can access or edit sheets. When I try to share the sheet, it says that I only have viewer access. My team members cant access the sheets at all. I renewed my subscription recently and it seems…
