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

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

Find more posts tagged with

Human Resources

Education

Reports

Attachments

Update Requests

Email Notifications

Comments

Andrée Starå

Hi Marylene,

I'd recommend using reports and send each month automatically.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Alejandra

Hi Marylene,

To add to Andrèe's response, reports can also be sent as recurring attachment, however, if you choose this route —you would need to create a report for each person. Since the current user filter only applies when a person is actively viewing the report.

Keep in mind, reports don't count against your sheet count and also, by sending a report as an attachment, recipients can view the report in PDF or Excel format, without having to be shared to the report.

When you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like to send a filtered sheet as a recurring attachment.

If needed, more information on the topics above can be found here:

Share a Report as an Attachment in Email: https://help.smartsheet.com/articles/516096-sharing-sending-reports
Creating Reports: https://help.smartsheet.com/articles/522214-creating-reports

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet -Ganhtt Chart
Is it possible to display both the planned and actual duration for a single task on a Smartsheet Gantt chart? I would like the Gantt bar to show the planned duration (e.g., in blue) based on a Planned End Date column, and then show the actual duration (e.g., in green) based on an Actual End Date column. Can the Gantt view…
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
Can we run the request for update to include all the rows that applied to one condition?
We want to know if it is possible to send request for update in one email, but with multiple rows at the same time. For example, staff A has 4 open referrals, I want to send one request for update automatically to them where they will receive only one email without having to overload them daily with all the open referrals…