This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 9%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
I dont understand why this seems so difficult. It really is a standard business requirement.
I want to store my quotes in SharePoint. This is fairly straight forward and I built something suitable no issue. I can store my word document I send to my clients etc. Great.
Now I want to add my cost sheet to the same line in the document library. In simple terms the line containing the quote document should hold a link or the cost sheet as a separate document on the same line so it is clearly related to the quote.
In other words any quote should contain two documents, the copy sent to client and the spreadsheet of the costing for that quote.
To date I have tried setting up a second library and linking the contents, however that doesnt seem to work. When I add the link I get no content listing displayed. I have tried adding content type but either this isnt correct or I am misunderstanding it.
This seems such a simple and hum drum thing to do, why it is being so elusive I have no idea. Any suggestions?
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
Well thats just weird...When I do this, this way it doesnt work????????????
Is there a setting I am missing?
Hi @David ,
Would you like to share you steps on setting the columns? From where do things wrong? If possible, please provide more information of your current situation, screenshots will be helpful.
And let me say a bit more about the key steps.
To complete the connection between the two libraries, Here are the points.
How are things going? Is there any update on your issue?
I am willing to hear from you.
I am checking to see how things are going there on this issue.
If you think my suggestion is helpful, you could mark it as an answer. It will help others who meet the similar question in this forum. Also others will directly see the answer.
Hi @David ,
Based on your description, I think you might want two libraries, one to store quotes and one to store cost sheets. And for each quote, we have a link in the same row which will direct users to the corresponding cost spreadsheet. It is recommended that to use lookup column to achieve this. If this is not your scenario, please let me know with more information of your current situation, screenshots will be helpful.
The screenshots below shows a simple demo in my end.
There are two libraries: Documents to store quotes and Cost sheet Library to store the cost sheet.
Documents:
Cost sheet Library:
Create a new column in the Documents named “Cost sheet link”, make sure the type is “lookup” and choose your cost sheet library in the “Get information from” and choose the column you want ,like title:
And then edit your properties to choose the spreadsheet you want:
At last:
After you click the “Cost sheet 1” ,you will open the corresponding spreadsheet.
Hope my clarification is clear. Please feel free to post back if you need further assistance on this issue.
Best regards,
Yanting Lu
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.