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, pleaseVisit the Current Forums.
Receiving "Invalid URL" When Attempting to Link Into a Share Drive Folder
Comments
-
Stefan 7k ✭✭
2017 is near closing and still no progress.
Online sharing and cloud storage shure is a great addition to old school network storage.
But, it should and must be an addition. Especially here in Europe there are a lot of companies which will never upload confidential date (regarding privacy or core company data etc.) to any kind of US cloud storage.
内容,请允许本地文件链接(discussion about the benefits necessary) for your customers and for potential customers!
In addition, Smartsheet should seriously consider to provide a data center within Europe. Like Microsoft, Salesforce etc.........
Projektmanagement Professional in Frankfurt am Main, Germany
-
Ben_H ✭
I would also like to request the ability to link to internal network files and folders. I manage projects across several offices involving dozens of personnel all of whom work from the same shared network and need to access the same files. I'm working on trialing different project management programs for our company, and this is the major drawback for Smartsheet at the moment. If we can't access all of the critical work files from one portal, then we have difficulty getting people to use the software and they end up working from Excel spreadsheets on the network drive rather than from Smartsheet.
Thanks.
-
Here is the correct syntax to link to a local drive: file://servername/share/folder
The problem is once the attachment is added in smartsheet and you click the link, it doesn't open file explorer location.
Due to ACJIS requirements, we store certain files locally, and other files using SAAS.
Smartsheet, THE UNITED STATES GOVERNMENT NEEDS YOUR HELP SO we can maintain certain compliance requirements.
Please respond with your position on this request. It has been 2 years since first requested.
Respectfully
-
Since I don't think the developers will implement this feature any time soon, I found a workaround that's suitable for our company needs:
1. Create a shortcut (*.lnk) for your file / folder you want to open
2. Upload this shortcut as attachement to your project / desired row
3. Now you can open this attachement easily from Smartsheet
4. When asking which program to use for opening, you don't have to choose a program, just activate the "Open with" radio button and hit OK
5. The following notification can be suppressed with "Never ask me again"
(6. You can delete the local shortcut now)
It's just a workaround, but works well for us. At least better than having to navigate to the folder manually. Hope this will help some of you.
Greetings,
Dominik
-
Stefan 7k ✭✭
Great finding! Thank you for digging this.
This does not remove the requirement for Smartsheet to implement links to local files ;-)
Projektmanagement Professional in Frankfurt am Main, Germany
-
We also would like this function to work in order to Link directly to Bluebeam Files withing a project studio. They are currently popping up as "Invalid URL"
Thank you
-
wael ✭
Strange that SmartSheet did not apply this requested feature.
Please add my vote to this request!
-
wael ✭
Hi Oliver! As a matter of fact, that is the desired experience! You have to be in the network to access these files.
Ultimately, even if you are considering the cloud shared folder option, with no permission you will have the exact outcome of not being able to access the file.
Allowing us to share files using our network permissions will help us a lot!
-
Add my organization to the request list for being able to link to an internal network location. We do not want certain documents on cloud servers for security. Also adding local links will serve us well in some items we want to do with Dashboards.
-
I would like to echo others' sentiments here and request this functionality be added to SS. Cloud is not an option due to sensitive data.
你可以把它基于多明尼克的指令a step further to get a hyperlink with UNC text that actually links to the file.
1. Create a shortcut (*.lnk) for your file / folder you want to open
2. Upload this shortcut as an attachment to your project
3. Select the attachment by ticking the check box, then click the Actions dropdown and choose Send Selected Attachment
4. Copy the smartsheet url(https://app.smartsheet.com/b/download/att...) and click cancel
5. Right click the cell, click Hyperlink... and paste in the Link to URL and then type out the Display text as the UNC path(\\server\path\file)I didn't see an easy way to pull the s3 link that downloads, but you can see it in curl.
-
ahill ✭
I would like to +1 this feature request too. As stated above, you can already navigate local directories natively using web browsers. Using smartsheet to link these shared company directories/files would be a huge help in many situations.
For instance, we use Smartsheet for KPI tracking, but use a shared network directory for storing KPI data. Providing a link on the KPI sheet to the shared directory with the supporting data would be helpful.
-
itsnotbroken ✭✭✭✭
Hi rollermover,
I did try the shortcut as attachment workaround, but the download fails. All that happens is that smartsheet re-loads the page. Maybe that's our firewall not letting me download a link.
Plus one for adding this feature, but it sure looks like smartsheet is NOT reading their own forums. We are in the testing phase & this response does not look good.
Thanks, -
John S. ✭
Dominik,
Is this workaround still working for you? I just tried to test your method and the .ink file is downloading as a '.download' file and windows does not know how to open it.
Update: Found out that the method works in Internet Explorer, but not in Chrome. Chrome changes the file extension to .download. -
John S. ✭
Just piling on...
I would also like to request that Smartsheet add the ability to link to local/network file and folders. This is incredibly important as many of your customers have IT policies against uploading confidential or sensitive information to cloud based services.
-
zachs ✭
+1 Would love the ability to hyperlink to shared network folders & files.
Categories
Instead of applying the formula to \"Multiselect Text String\" row, did you tried with \"Multiselect Values\" row?<\/p>
=IF(HAS([Multiselect Values]@row, [Component ID]@row), \"MATCH\", \"NO MATCH\")<\/p>
Thank you,<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":109493,"type":"question","name":"I am having trouble using \"And\", \"OR\" & \"Countif(s)\" to build a formula.","excerpt":"Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5 different statuses in a separate column. So using the screenshot I've provided as an example (although it doesn't have 5 different statuses in the…","snippet":"Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5…","categoryID":322,"dateInserted":"2023-08-25T20:03:21+00:00","dateUpdated":null,"dateLastComment":"2023-08-26T00:34:49+00:00","insertUserID":165710,"insertUser":{"userID":165710,"name":"SmarsheetNewb","url":"https:\/\/community.smartsheet.com\/profile\/SmarsheetNewb","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-26T00:33:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-27T02:16:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3386005690,"url":"https:\/\/community.smartsheet.com\/discussion\/109493\/i-am-having-trouble-using-and-or-countif-s-to-build-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109493\/i-am-having-trouble-using-and-or-countif-s-to-build-a-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109493,"commentID":392692,"name":"Re: I am having trouble using \"And\", \"OR\" & \"Countif(s)\" to build a formula.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392692#Comment_392692","dateInserted":"2023-08-26T00:34:49+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-27T02:16:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-26T00:33:25+00:00","dateAnswered":"2023-08-25T20:44:12+00:00","acceptedAnswers":[{"commentID":392662,"body":"
Try this:<\/p>
=COUNTIFS([Item Number]:[Item Number], OR(@cell = \"C001\", @cell = \"COO2\", @cell = \"COO3\", @cell = \"COO4\"), [Status]:[Status], OR(@cell = \"Green\", @cell = \"Yellow\", @cell = \"Red\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109500,"type":"question","name":"Auto-populate emails on a \"contact list\" column","excerpt":"I have a Form created for internal employees where they can submit request tickets to my department. We all have an account with Smartsheet. One of our columns (\"Requestor Name\") is in the Form where they type in their names. The \"Requestor Name\" column is a Contac List column. My issue here is, how can I have Smartsheet…","snippet":"I have a Form created for internal employees where they can submit request tickets to my department. We all have an account with Smartsheet. One of our columns (\"Requestor Name\")…","categoryID":321,"dateInserted":"2023-08-25T21:43:36+00:00","dateUpdated":"2023-08-25T21:44:14+00:00","dateLastComment":"2023-08-25T22:14:15+00:00","insertUserID":164850,"insertUser":{"userID":164850,"name":"ocanel","title":"Analyst","url":"https:\/\/community.smartsheet.com\/profile\/ocanel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-27T06:55:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":164850,"lastUserID":165374,"lastUser":{"userID":165374,"name":"Shanky Paul","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Shanky%20Paul","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtcAdE60g-MBEj1rR28GVz9zn6RmbZsmEQm5EiEV=s96-c","dateLastActive":"2023-08-27T08:29:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":null,"hot":3386002071,"url":"https:\/\/community.smartsheet.com\/discussion\/109500\/auto-populate-emails-on-a-contact-list-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109500\/auto-populate-emails-on-a-contact-list-column","format":"Rich","tagIDs":[204,247,334,448,527],"lastPost":{"discussionID":109500,"commentID":392677,"name":"Re: Auto-populate emails on a \"contact list\" column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392677#Comment_392677","dateInserted":"2023-08-25T22:14:15+00:00","insertUserID":165374,"insertUser":{"userID":165374,"name":"Shanky Paul","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Shanky%20Paul","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtcAdE60g-MBEj1rR28GVz9zn6RmbZsmEQm5EiEV=s96-c","dateLastActive":"2023-08-27T08:29:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-27T06:55:03+00:00","dateAnswered":"2023-08-25T22:14:15+00:00","acceptedAnswers":[{"commentID":392677,"body":"
Hi, <\/p>
Add a \"Created By\" column in your sheet and turn on \"Required smartsheet login to access your form\" in your form setting. So that whoever fills out the form, their email id will be automatically captured in \"created by\" column. This will replace your \"Requestor Name\" column. <\/p>
Thank you!<\/p>
<\/p>