Row Specific Notifications

Hello,

I have a workflow set up that is a set of sequential actions, each with their own row. I'd like to send a specific email to the owner of the next row when the previous is completed. This email is specific to the task on their row.

Example:

Row 1- Create employee ID

Row 2- Grant access to systems

Once the employee ID step is completed, I want to notify IT to start their process. Everything I've seen so far is column based vs. row based. Can this be done?

Find more posts tagged with

Templates

Email Notifications

Comments

Andrée Starå

Hi Todd,

Yes, it is. Is the structure always the same?

One way to set it up would be to have a checkbox on Row 1 that is linked to a checkbox on Row 2 and so on.

Would that work?

Have a fantastic week!

Best,

Andrée Starå - Workflow Consultant @ Get Done Consulting

ToddW

That could work as the template doesn't change. From there, how can I create the specific notifications?

Andrée Starå

Great!

There are a few ways to do it. The easiest would probably be to add columns for each action and then link the checkbox from the starting row to a checkbox in the following row.

There are other ways to set it up, but it involves a more complicated formula structure.

Let me know what you think!

Would that work?

Best,

Andrée

ToddW

That should work. Thanks!

Andrée Starå

Great!

Happy to help!

Best,

Andrée

Mike Wilday

Wow, very interesting solution Andrée. I might have to incorporate this into my projects. Currently, we add a "Handoff column and when assigning tasks we add the user of the following task to the handoff column of the task before it. Your solution means less data entry (less room for user error) and is simple to implement. I like it.

Andrée Starå

Thanks, Mike!

Happy to hear that you like it!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…