Notify the record creator when a comment is made

I have a rule set up as follows:

When a row is updated, notify Created By right away

I thought this would send a notification to the email address in Created By when a comment is added, updated or deleted, but it doesn't appear to be working. Am I doing it wrong?

Find more posts tagged with

Email Notifications

Comments

Alison

Hello Tom,

Thank you for this question!

I was able to test this and trigger a notification based on a comment being added when my Notification rule was set to "When anything on the sheet changes." I've attached an example of my settings below. Please let me know if this does not work for you!

If you're adding these comments and not receiving these notifications, you may want to check if you have your Personal Settings set to notify yourself of your own changes.

This can be set under "Account" > "Personal Settings" > "Notifications" > check "Include my changes in sheet notifications" checkbox.

Please let me know if you have further questions on this.

Kind regards,

Alison

Smartsheet Support

Screen Shot 2018-01-31 at 8.09.34 AM.png

Tom Isaacs

Hi Alison,

Many thanks for your reply. I only want to notify the creator of the row which has changed, the creator is stored in a Created By column as the rows are created from a form.

Tom

Alison

Hello Tom,

Thanks for clarifying this! I think that you can make this work with a System Column as well; I just did some testing and I was able to see the notification come through with a rule to notify when "a row is added, updated, or deleted" set up to go to a "Contact in column." I was able to choose my Created By System Column as well.

I've attached an image of how I have that set up below.

Please let me know if you do not see this work.

Kind regards,

Alison

Smartsheet Support

Screen Shot 2018-01-31 at 9.01.17 AM.png

Tom Isaacs

Hi Alison,

I've set up the rule as per the attached screenshot but the creators are still not receiving notifications for new comments. Could there be a conflict as I also have a rule notifying me of any changes?

FYI I have tested this on email addresses within our organisation and also personal email addresses (gmail) to ensure there wasn't a firewall/spam filter issue.

Tom

Tom Isaacs

Thought I'd follow up to this. I added a notification to a record today and instantly received an email warning that there were invalid recipients for my alerts, not something that has happened before, is this a new feature?

"To include these recipients, you may need to do one or more of the following:

1. Check your Alerts & Actions Permissions. Click on the Alerts & Actions tab at the bottom of your sheet. Click the Settings icon to modify permission levels to include the invalid recipients.

2. Edit your notification recipients. In Alerts & Actions, edit the rule named "Notification to submitter when something changes" by double-clicking it.

3. Check with your account administrator to ensure appropriate email addresses are whitelisted for your organization."

Anyway, I found the settings icon and modified the setting to allow notifications to any email address and it all appears to be working as expected now.

Tom

Sign in to join the conversation!

Quick Links

Trending discussions

Excluding All Categories with 0s from Dashboard Graph
I have a Sheet with multiple columns the values that make up these columns are derived from a count formula. I cannot figure out how to generate a report that allows me to exclude only the columns that have zero values. I am trying to filter the report in a way that only the columns (which are categories) that are greater…
If you switch your Grid View to Table view, can and will your sheet stay as a table view permanently
I ask this question because i have switched my grid sheets before to table view and exited out of the sheet, then when i come back its back in grid view. Just wondering if thats normal. thanks
Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…