Row limit on Daily/Weekly Email Summaries

Charity L

Hello, we have 2 workflows set up to send a daily and a weekly email of all the rows that have been added or changed in a sheet. We notice that it doesn't show all the rows in the image table within the email, and at the bottom of the table it says "Additional changes were made in ___ more rows."

Is there a limit to how many rows might show up in an email?

How can I see these other rows or is there a link/way to to see all these changes in one view? Thank you!

Brett Wyrick

Hey Charity.

Correct if I'm wrong, but it sounds like you're wanting the ability to see more rows in this "Summary Email" so you can more easily see the new rows that are added. Is that accurate?

If that is the question you're wanting an answer for, unfortunately, there's no way to limit the amount of rows that show up in an email for these sorts of notifications. Smartsheet, bless its heart, does a lot of things really well but notifications are not its strong suit in my opinion. I'm the same as you, I'd like a line-by-line measure of all items that have been added (or updated!).

Due to the way that Smartsheet saves (it requires either a manual process of a person pressing the "Save" button or it auto-saves sometimes), notifications are passed in batches. So if I add 7 rows, all 7 rows usually get put into one notification. Smartsheet may parse out the first 2 (like what you have above), but what about the other 5? I ended up creating a custom solution through Microsoft's Power Automate that gives a "project newsfeed" of each item updated to particular channels to circumvent this.

But, for what you're looking for, I think a Report would be a solid option.

Proposed Solution: Create a report and receive an Excel file daily via email

Create a Report for this sheet named something similar to "Added today", and another for "Added last week". Add the fields you'd like to see (might be all the fields for the sheet). Then set up an email to go out daily with an attached Excel file.

1. Create a report for this Sheet named "Added today".
   1. You can choose the "Filter Criteria" to be like this for "Added today":WField: Created
   2. Filter: "is in the last ____ days"
   3. Criteria: 1
2. Within that report, go to File -> Send as attachment... then select "Schedule". You could set it up to be recurring like your current email summary. For more detail, check this help article from Smartsheet: Share a Report as an Attachment

Let me know what you think.

If this solution works for you, please mark "Yes" - that helps others looking for a solution similar to this to find this post (and you random Googlers out there 👀).