How can I prevent to copy data from a sheet to another file? I need share some sheet with editor privilege, but I have to prevent he to copy the data to another place. Thanks, since now.
If you give them editor rights, they can see everything and even make changes to it. The simple fact is that if they can access the sheet from within Smartsheets - they can copy the data.
The only way to prevent users from copying data is not to give them any access to the sheet. Even viewers can copy.
You can make it harder by only sending them .pdf exports of the sheet regularly, but the still must not have access to the sheet if you want to prevent copying.
You 'might' be able to remove their access to the sheet and then send them Update Requests for the things they need to change - but if they need to make changes regularly then that is not really an option worth entertaining.
If they can see the data they can copy it down. even if smartsheet didn't give them the ability to copy paste they could write it down by hand or use dual monitors to type it up. There really isn't any functional way smartsheet can prevent this.
Thanks, I'm new on this platform, I figured it could have a function like excel, which blocks the spreadsheet leaving only a few cells available.
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.