Reminder when items assigned to user

Hi All,

This is probably something easy to do, but I'm still a little new to SS administration. I have a issues log that has a "Assigned To" Column (using contact list) and a "Modified Date" (system). I am trying to find a way to send the "assigned to" user a reminder email anytime something has been modified and the "assigned to" has been changed.

In other words, I might have an item that is assigned to myself, and I may be updating it with comments... but I don't need a reminder email sent to me. However, once I reassign to another user, I want that user to get a reminder so they know the item is assigned back to them.

Any help is appreciated!

Find more posts tagged with

Formulas

Project Management

Email Notifications

Comments

Mike Wilday

This could be accomplished rather easy with the new notifications. Click on the Alerts tab in the bottom bar of the window. And choose new notification > "When a row is assigned"

Be sure that your Assignee row is a contact-list type of column. You can right-click on the column header to ensure this.

Thank you,

Matt Stofka

Hi, cfarrow2112. You can do this using Alerts/Notifications which will send an email notification to the person in the Assigned To column as soon as it changes.

On your sheet, click the Alerts tab at the bottom, and then:

Click Notifications
Click New Notification
Select When a Row is Assigned
Name your Notification something meaningful
When: select when Assigned To changes to Any Value
Email: select Assigned To > Right Away (or you can choose one of the other options to send them less frequently)
Click Customize Email and adjust the email Subject line and Body to something meaningful
Click Save

Optionally, you can also add other conditions wherein this Assigned To change has to correspond with some other value in the column.

Hope that's helpful.

Matt