Send alert/notifications including headrow and children rows in the attachment

edited 12/09/19 in Smartsheet Basics

Hi All,

I want to send automated notifications to my employees containing their absence records.

To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their children rows (1 row per period of absence) as attachment.

So far I can only do this manually by selecting the rows and chose send. (one by one for 250 employees)

I'm looking to find a way to do this for all my employees every month at the start of the month.

Any idea's?


Thank you 

absence records.jpg