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:
We have a shared One Drive account and I would like to create a hyperlink to certain documents that are password protected to certain users of a Smartsheet. Is it possible to do this so only those with a password can open the documents (either in Excel or PowerPoint)?
I'm not using onedrive but I think this may be similar. I have put a hyperlink on a dashboard to an excel document saved to box.com. When I click on the file it opens in the box.com (web interface) as view only. From there I can open it in Excel online or using the desktop installed excel (after boxtools is installed). If I want to password protect the file I would do it in excel not in smartsheet. I believe the same can also be accomplished using the attachments field in any sheet.
I have added a password but the other users cannot open the document. They get an error message to say the file is encrypted and no option to open it in the online Excel or PowerPoint as I do.
Similar to Mike's response. If you are using OneDrive my suggestion is to use the permission structure inherent to OneDrive rather than locking an Excel file. I use it constantly without issue. Smartsheet has built in OneDrive support.
https://www.smartsheet.com/apps/onedrive
Locking fields and sheets are a separate issue.
Hello, smarter friends: I'm trying to learn how to utilize automations to move certain rows to new sheets in order to explore if my larger/longer ranging goal is possible. Where I'm Currently Stuck: I can't even figure out how to create functional auto to send a row to a basic sheet. That is my immediate need. But if…
I'm having issues accessing Smartsheet in both the desktop app and web browser and continually get the below error message…I need to refresh multiple times to get it to work. And sometimes it works and sometimes it doesnt:
This just started today… For some reason, I can no longer edit fields in my Smartsheet. One I'm the owner of. I do see an icon in the upper right that says "Comment Only", but can't figure out how to change it. Here a screenshot of what I am seeing:
