Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Setting up notifications and alerts
I am going to have a sheet made for every lot that we land survey on which adds up to a lot. Each sheet I have 13 rows of tasks and 13 rows of columns, 12 of them being contacts and one of them being status of the task.
I am trying to set up the notification or alert to contact those in the contact columns when the status has been updated. The contacts for each task are all the same down the rows per sheet.
Here is my issue:
These contacts change from time to time so I need to cell link each contact from another sheet which has the contacts on it so if the contact changes we don't have to go in every sheet and change the contact and only have to do this in the contact sheet. I need an easier way rather then cell linking 156 cells (12 contacts x 13 tasks).
I have all my contact columns set up as text/number so I can put a formula =PARENT in the 13 task child cells because the formula doesn't work as a contact. So I cell link the parent row from the contact sheet and it brings over their email address.
I thought this worked but it's only working for those who are shared to the sheet and I made sure I have "any email address" selected in my user management settings and in my notifications and alert settings.
I need a better solution if anyone knows a work around for my issue.
Thanks thanks thanks!
Comments
-
Hi there,
To streamline your process, I'd recommend checking out a third-party automation service, like zapier, azuqua, or appsheet.
These services may be able to automate the changes to your destination sheets based on your source sheet with all of the contacts without you having to manually create cell links.
If you have development resources available, you might also check out our API: https://smartsheet-platform.github.io/api-docs/
Otherwise, if you'd like to work with someone from our team on a custom solution, check out our consulting page: https://www.smartsheet.com/consulting
-
Hi Dillon,
This might help!
Formulas in contact columns. It's released now!
https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives