Sending report link as automated alert
Hi. I'm sending a link to my report in an automated workflow as an "Alert Someone". The recipient email contains a link to the report and a snapshot of the report, but it is limited to 100 rows. A message appears at the bottom that says 18 more rows not shown. Is there anyway to include all rows in the report in the email, so the recipient does not have to click on the link to open the report?
Best Answer
-
Hi Sandra,
Based on this screen capture, it looks like you have an alert from a sheet which is filtering the rows sent to the user - this type of automation can only show up to 100 rows, as you've found (see the second bullet point in this Help Center article).
As an alternative to sending an alert from a sheet, you could set up a recurring email from the Report itself. This would send the Report as an email attachment, so the body wouldn't appear in the email itself, but it would include all of the rows in the attachment (see this article, here).
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi Sandra,
Based on this screen capture, it looks like you have an alert from a sheet which is filtering the rows sent to the user - this type of automation can only show up to 100 rows, as you've found (see the second bullet point in this Help Center article).
As an alternative to sending an alert from a sheet, you could set up a recurring email from the Report itself. This would send the Report as an email attachment, so the body wouldn't appear in the email itself, but it would include all of the rows in the attachment (see this article, here).
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives