Sending Alerts to Contacts w/o Sharing

I have a sheet with information that is not confidential yet isn't information I want to share with all vendors. The managers who can view the sheet already need to see all of the information currently in the sheet. (As the owner, I have other information in columns hidden from other's views )

I set up alerts to go to vendors when a manager approves a task. The vendor has no reason to view the sheet, but I want to keep them updated on the status of a task.

I set up automated alerts to trigger when the status is changed, but I am getting an email that the recipients (who are just vendors and do not use or need to see info on sheet) cannot receive alerts unless I share the aheet with them.

Any work around? I don't want vendors to be able to access or view the sheet. Anyway Smartsheet can still send them an alert? They are are already added as Contacts in the Sheet.

Find more posts tagged with

Sheets

Contacts

Comments

Andrée Starå

Hi,

Yes, you have to change the Automation Permission setting to Unrestricted, and then they won't need to be shared to the sheet.

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

ipeat

Our Automation Permission setting is Unrestricted, however the send to contacts in cell automation is only sending to Smartsheet users. Normal send function works fine with same contact.

Andrée Starå

Hi,

That's strange!

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

ipeat

There are sheet specific automation permission as well as system-level automation permissions.

Screen Shot 2019-07-16 at 9.13.17 AM.png

Screen Shot 2019-07-16 at 9.13.51 AM.png

unknown

This content has been removed.

Andrée Starå

Hi,

In the Advanced Options of the Workflow, you can change what to include. (see attached screenshot)

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Adcanced options - Column visibility.png

Ramsay Zaki

I have my Automation Permissions set to Unrestricted in at the Account Admin level. However, when I create a new sheet, it defaults to Restricted. I can change it to Unrestricted for that sheet but it doesn't default to Unrestricted. How can I default it such that all newly created sheets get the Unrestricted setting?

Andrée Starå

Hi Ramsay,

Adding the same answer from another post so other easily can find it.

@Ramsay Zaki

It's by design for security reasons.

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

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post 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!

Narasimhamurthy Prahaladarao

Is it possible to send alert to contact in cell and also to specific people/Cc me on notification.

Andrée Starå

Hi @Narasimhamurthy Prahaladarao

Yes, you can add another Action to include specific people.

Make sense?

I hope that helps!

Be safe and have a fantastic week!

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Access report
Hello. Me and my team are doing an audit of users who have access to edit items in our account and one of the reports we're using is the Sheet Access report under the User Management section of the Admin Center. However, we're running into some weird things. When we dig into the Sheet Access report, we sometimes notice…
Does sheet access require new users to create a smartsheet account?
No License required I am sharing a published link, no license required to a group of people. The goal is for them to be able to edit the sheet. Would each member be required to create a smartsheet account? Please, is there a way for them to access my sheet without having to create an account? Many thanks!
Backspace, enter and delete keys not working...
This has happened a couple of times before. However, when trying to update a form or even a field in the smartsheet, I am unable to use the backspace, enter or delete key. I use Google browser, however I wasn't sure if it was Google, so I switched to Microsoft Edge. Still not working. Also, I tried using the backspace,…