Setting up notifications and alerts

DillonHug

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!

Shaine Greenwood

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

Andrée Starå

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