Can I get a notification when a new collaborator has been added to a sheet?

Ivonne Mejia

Hello,

I have multiple sheets and dashboards created for different departments.

We are allowing editors the ability to add collaborators to their sheets. I need to track who has been added as a new collaborator across all the multiple sheets so I can add these users in their specific groups (which grant them access to view some dashboards).

Is there a way to get a notification every time someone is added or removed as a collaborator?

Ivonne Mejia

Hello,

In case anyone needs to know everytime a sheet is shared (a new collaborator is added, collaborators are deleted, or permissions are changed) I found a hidden workflow that does that.

Just go to Automation / Manage Workflow

From the dropdown list go to the end and select "Basic Workflows..."

Select "Alert someone when this sheet is shared".

This is what I needed and it works!

Andrée Starå

Hi Ivonne,

Unfortunately, as far as I know, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment to have your vote added

As possible workarounds, you could maybe use the Download the Sheet Access Report from the Account Administration area or use the premium add-on, Event Reporting.

More info:

There is a premium add-on, Event Reporting that can provide you with much more information. Is that an option?

More info: 

https://help.smartsheet.com/articles/795920-manage-users-multi-user-plan#manageactions

https://help.smartsheet.com/articles/2479296-event-reporting-monitor-how-data-is-used-across-your-organization

Would that work/help?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

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

Ivonne Mejia

Hello,

In case anyone needs to know everytime a sheet is shared (a new collaborator is added, collaborators are deleted, or permissions are changed) I found a hidden workflow that does that.

Just go to Automation / Manage Workflow

From the dropdown list go to the end and select "Basic Workflows..."

Select "Alert someone when this sheet is shared".

This is what I needed and it works!