Document Folder
Hi everyone,
I need your help. I have a project sheet where each row contains multiple documents attached. I am looking for a way to create different folders and save the documents in the folders. Or how can I save documents to my SharePoint folder.
Any idea will be appreciated.
Thanks.
Answers
-
Hi @AghoT,
A simple way would be to create folders (or better still use Document Sets!) in SharePoint, with names that match the value a cell in your Smartsheet project register – such as a 'ProjectID' primary column name/number perhaps?
In that way, you could create a global Smartsheet Sheet Summary text field called 'SharepointProjectsURL' and enter your SharePoint tenant, site name, and projects library name (e.g. "https://MyOrganisation.sharepoint.com/sitename/projects/"), then add a Smartsheet column (e.g. called 'ProjectDocsLink') and create a column formula that calculates the full URL for the folder:
= [SharepointProjectsURL}# + ProjectID@row
This will create a clickable link to your specific SharePoint project folder.
Adrian Mandile
CHESS Consulting Australia - Smartsheet Solution Provider Gold Partner
Collaborative | Holistic | Effective | Systems | Solutions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives