bulk edits

Hi i have a large sheet that needs to be edited by many individuals [circa 30].

Each row contains in a field the email address of the user who can edit or modify the record [row].

Is it possible to:

automate an invite to edit based on parsing the sheet per unique set of emails

restrict for a user to edit only those records which contain their email field. [not worried if they can view other records, but no edit options on these]

If the above cannot be done in an automated fashion. What's the next best approach manually.

Many thanks Mike

Find more posts tagged with

Sharing and Collaboration

Security

Solution Center

Email Notifications

Comments

Andrée Starå

Hi Mike,

If possible for your use case I would suggest that you use the update request feature. The user receiving the request can only edit that row of information and only once. Would that work for your use case?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Mike Wilday

Hi Mike,

Another option might be to create a report from the main sheet that only shows their content.

The downside is the main sheet remains editable by everyone, but if they are only referencing their reports, they will only see their data. If your crew is trustworthy and you make the process clear, this might be a solution for you. Because their row(s) would be editable anytime and their rows are the only ones they would see. You can also use the current user report to only manage a single report for all your users. See the following link for more info on creating reports.

https://help.smartsheet.com/articles/522214-creating-reports

Sign in to join the conversation!

Quick Links

Trending discussions

Viewers and Permissions after new pricing model
I have provisional users who, under the legacy model, were unlicensed users with editing permissions for workspaces. I’ve now changed their role to "viewers" and assigned editing permissions to specific workspaces, aiming to maintain the same editing experience as before. However, they cannot edit fields within tasks or…
Delete inactive smartsheet account
I'm trying to figure out how to delete an inactive Smartsheet account so I can use that email address for another account. The account I'm trying to delete was a free account with no system admin, so there's no one to contact. The AI bot with the Help Center told me my only option was to use the Smartsheet Community. Any…
Phone number validation won't allow all zeros
Hi- We have been using a SmartSheet Form for a while, and users have been able to enter 000-000-0000 if they don't know a person's phone number. However, over the past few days, it appears that the phone number validation field will not allow all zeros any more. Is there a way that I can change this? We would like the…