Notification without parent row

Options
Ofir Marco
Ofir Marco ✭✭
edited 12/09/19 in Smartsheet Basics

Hi all,

Have some rows hat are sub tasks below a parent row.

Those rows are assigned while the parent is not assigned.

I have a notification with a rule that sends a notification when someone is assigned.

Problem is that it sends the Parent row as well.  in the specific case we don't need it since it has the same data as the child row.  (this is a courses submission tracking sheet)

Is there a way to eliminate parent rows from the notification mail table?

 

Parent is shown on the notification.png

Comments

  • Chris McKay
    Chris McKay ✭✭✭✭✭✭
    Options

    Hi Ofir,

    If your Notification is configured to send when a row is updated, deleted or modified, then chances are the parent row is also changing which is why it is included.

    To get around this add a column that contains a formula denoting the row as a Parent or Child row. You can do this with a COUNT(CHILDREN()). Then configure your notification to only send notifications for rows that have a COUNT(CHILDREN()) value of 0.

    Hope this puts you on the right track.

    Kind regards,

    Chris McKay

  • Corinne Flanagan
    Options

    Hello,

    Just a point of clarification, there isn’t a way to exclude parent rows from notifications on changes made to child rows. The formula mentioned above by Chris will work to exclude the parent row in some situations, but not with notifications. With notifications, it will return the parent row in the notification along with the child row.

    Check out this article on notifications from our Help Center for more information:https://help.smartsheet.com/articles/542904-using-notifications