Notification without parent row

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

Find more posts tagged with

Update Requests

Enhancement Request

Email Notifications

Comments

Chris McKay

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

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

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…