Notification when comments change

Brett Evans

I am trying to get automaically notified when someone adds a comment in the System comments column (circled in green).

 

Thoughts?

Brad Jones

Wait, not getting alerts when YOU make the change?  This is old behavior.  The system will not show you your own changes.

 

As for comments not working, that's a good question.  Could have something to do with SS not considering a change to a comment as a modification to that row.  Hope it's not a new bug.

 

Brett Evans

Brad,

 

you were correct - the system does not send notification when you make your own chnages.  I was trying to test the notification for comments before rolling it out to users.  I forgot that detail of notifications.  So it's not a bug, but a feature.

 

Thanks,

Brett

J. Craig Williams

If you do need to be notified of your own changes (like I do sometimes), I have two methods:

 

1. I have a second unlicenced user that I can have the notification sent to - since it goes to the same email, it is as if it were me. 

An email like this

my_name@gmail.com 

and

my_name+alerts@gmail.com

 

both go to the same email address according to Google but are different users according to Smartsheet.

 

2. Zapier (www.zapier.com) can trigger on new comments.

It won't trigger on updated comments.

 

Craig

 

Natalie Gorman

Hi Brett

 

What is the purpose of being notified when you personally make a comment? 

 

The reason I ask is that I wanted to run a report that would provide me with 'all' modifications, including comments, which is possible if other cells in that row are changed at the same time.  However if only the comment is updated, the report does not show this.

 

My work-around is to export both the report and the comments from the sheet to Excel and I have written a macro that with a little bit of manual tweaking provides me with excel workbook with the information I require.

 

Natalie

gamgc

Craig,

You say that Zapier can trigger on new Comments, as vs updated ones. I have not been able to get it do so. Adding a comment does not trigger an updated SmartSheet row in a Zap I have been trying to get to do so. How did you go about it, please?

Regards,

GAM (Glen A McAllister)