Send notification without access to sheet

I am wanting to create a workflow that will send a notification to a contact listed in a row without allowing access to the sheet itself. Specifically, when I receive a notice to vacate from a resident in one of our apartment buildings, I would like to send them an acknowledgement that it was received when its added to the sheet and I check a box. When I create the workflow, it provides access to the whole sheet. I've tried sending the row as an attachment, but then it sends all columns when I only want a select few.

Find more posts tagged with

Sheets

Sharing and Collaboration

Real Estate

Support

Project Management

Email Notifications

Comments

Sheryl P

You can send notifications to people who are not set as Viewers on a sheet. Check the configuration settings on workflow (the cog wheel). Then use conditions to filter to just the row for that apartment, or individual. There are several ways to accomplish - do you need to track that the notification was sent? This sometimes drives the method I choose.

Jim P

Once you update your workflow settings, unrestricted is the best way to do this, then you can have a workflow that will email an acknowledgment to an individual from a Contact List cell. You will want to have a column that is a Contact List Type. Here you will put the persons email address, and then the workflow will send the notification to that email. You can restrict which columns, if any, are sent with the email.

To find the columns you want to send, or do not want to send, click on the 3 dots on the top right of the condition within the workflow.

The email will have a link that the other person can click on, but as long as they are not shared, they will not be able to see anything.

Andrée Starå

Hi Sarah,

Here's where you change the settings.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Pesonal Settings.png

Automation Permissions.png

unknown

This content has been removed.

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…