Alert when adding a new row

operations82501
edited 12/09/19 in Smartsheet Basics

Hi,

 

We have a sheet where we keep track of current statuses of our clients and this act as a mini project management tool for our clients. 

 

Each client is in a row and the stages are indented underneath. We would like to create an alert to notify specific persons everytime a new client is added, and this we have done it by setting up to send an alert when a new row with client name is added. Thus, since underneath the main row we keep repeating the client name, if the project will have 12 rows, we are receiving 12 notifications, while we require only one, for the parent row.

 

N.b. we are writing the name of the client in the children rows so when we send updates about a particular role we can write {{client name}}, thus if somehow we can pick up the parent cell, we shall be solving the problem, assuming..

 

How can we go around this please?

Comments