Automated Notifications coming from various contacts
![Alan Rappa](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
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.
-
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
-
You're more than welcome!
I saw that Susan answered already!
Let me know if I can help with anything else!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives