Automated Notifications coming from various contacts

Alan Rappa

Ok my friendly, neighborhood, Smartsheet Gurus - this has got me stumpted and I need your assistance.

I have a sheet that sends out automated notifications to a contact list as well as myself when a project hasn't been actioned within a few days.

The notifications are working as designed, however, they are sent from seemingly random contacts in the sheet.

For instance, I have several emails in my inbox for these notifications all from different senders (via Smartsheet)

Colton W via Smartsheet

Heena P via Smartsheet

Bill M via Smartsheet

When I review the rows, these contacts are not mentioned anywhere (in some instances, the contact list is blank for the row).

Is there something that is triggering the names that Smartsheet is using to send the notifcations on behalf of? I am truly scratching my head at this one.

Happy to provide more information if needed.

Thanks in advance

-Alan

Andrée Starå

Hi @Alan Rappa

Is it those users that are making the changes that trigger the alerts?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Alan Rappa

HI Andree,

Thanks for your response.

To clarify, these are automatic notifications:

I have a column called 'project age' that calculates created date to current date

When Project Age - 2,4,6,8,10,12... a notification is sent out to contacts in a cell that the item is still pending.

What is happening is it is coming from varying individuals.

As I type this out though, I am begining to wonder if it is using the name of the current user who opens the sheet in the morning, allowing the project age column to update and the notificaiton emails to be triggered (I don't think the project age column updates if the sheet is not opened).

Does any of that make sense?

Thanks again for your help

Susan Peck

Hi Alan,

This is a "feature" Smartsheet implemented last year. Automated emails come from the sheet owner if multiple changes were made. If only one change was made, they appear to come from the person who made the change.

Here is a longer thread on this topic. Please fill out a Product Enhancement Request to ask SS for some options on this feature.

https://community.smartsheet.com/discussion/67525/upcoming-changes-to-our-automated-notifications-live-today-17th-april-2020

Alan Rappa

Ahhh, Thank you @Susan B Peck

That makes sense.

In my case, I am the sheet owner - however Colton opened the sheet, therefore 'changing' the Project Age column which is why the notifications appear to come from him.

I will have to think of ways to mitigate this, as it is causing confusion amongst the team.

Thanks for the insights

Have a great day

-Alan

Andrée Starå

@Alan Rappa

You're more than welcome!

I saw that Susan answered already!

Let me know if I can help with anything else!

Best,

Andrée