Global Automation Permissions?

Kyle Chipman

Are there global automation permissions, where the Limited option can be set across the board? All I could find was Permissions in Security & Controls. For any new sheet created, I want to default the Automation Permissions setting to Limited.

Not sure if I'm overlooking something simple. Thanks kindly!

Kyle Chipman

Andree,

I appreciate the response. Doubly appreciate the safe + fantastic weekend sentiment :)

I was thinking more specifically about setting global initial-load conditions for Automation Permissions as opposed to constraining the options for sharing to Only shared users & people in your account. Sheets will still load with Restricted as the default option even with this option selected. I also want to keep third-party apps available for automation to Teams.

I'm about to spin up a bunch of sheets with notifications triggering to users account-wide, and not having to click Automations then the Gear to change this setting would save considerable time. The first bullet point in your summary shows this step is necessary. Alas.

Also, as long as we're chatting, thank you for all your responses and guidance over the years in the community. Your name is always there to lend a helpful word of advice or guidance.

Regards,

Kyle

Andrée Starå

Hi @Kyle Chipman

Yes, there is, and those are the options available. It's a little confusing because the naming isn't the same.

To set it to Limited, you'd select the Only shared users & people in your account option.

Automation Permissions

Control who can receive automation from sheets based on their sheet access and relationship with your organization. Options are organized from Restricted (only users shared to the sheet) to Unrestricted (any email address and third-party integration, such as Slack).

Keep the following behavior in mind:

• All sheets are created with Restricted permissions, so sheet owners and admins must manually make automation less restrictive at the sheet-level if desired.
• Sheet owners and admins will only be able to select sheet-level automation permissions that are equally or more restrictive than the account-level automation permissions.
• If any sheets are Unrestricted or Limited, and you set the account to be more restrictive, then those sheets will automatically adopt the more restrictive setting. However, if you then set the account to be less restrictive, then the sheets will return to their prior state unless they were manually set to be more restricted than the account settings.
• If a sheet is manually set to Restricted or Limited permissions, and you adjust the account-level automation permissions to be less restrictive, the sheets will remain unchanged.

NOTE: Individual email addresses must meet the account's approved domain sharing restrictions in order to receive automated email notifications.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Kyle Chipman

Andree,

I appreciate the response. Doubly appreciate the safe + fantastic weekend sentiment :)

I was thinking more specifically about setting global initial-load conditions for Automation Permissions as opposed to constraining the options for sharing to Only shared users & people in your account. Sheets will still load with Restricted as the default option even with this option selected. I also want to keep third-party apps available for automation to Teams.

I'm about to spin up a bunch of sheets with notifications triggering to users account-wide, and not having to click Automations then the Gear to change this setting would save considerable time. The first bullet point in your summary shows this step is necessary. Alas.

Also, as long as we're chatting, thank you for all your responses and guidance over the years in the community. Your name is always there to lend a helpful word of advice or guidance.

Regards,

Kyle

Andrew Stills

Any chance this has been changed or has a work around? I have many projects with "private information" for which individual lines need to be sent at specific times without conveying / opening up the entire project to the recipient?

The "Restricted" option prevents this ability and forces a rebuilding and entering of the emails on each project. This makes the automation not very automated.

Any ideas?

Thanks, Andrew

Andrew Stills

Wait... Hold on...

Here was the answer which worked for me. (Not sure what limitations might be imposed on other org's.) https://community.smartsheet.com/discussion/72434/automation-permissions-ap

When copying the template it is important to open the "Automated Workflows & Alerts" dropdown and select the "Include recipients & permissions settings" option.

Ramsay Zaki

Re-opening this question... I know the Account Level security setting where you can let people select "Unrestricted" -- but every time we create a new sheet it defaults to Restricted and we have to manually change it to Unrestricted. Is it possible to have all sheets automatically go to Unrestricted?