Can a weekly report not include information from last week?

I have scheduled an attachment to be sent via excel every week to the recipient. It includes information of terminations that need to be made. At the moment, in the sheet there is a checkbox that you tick when you want it to be terminated and a termination date that you include.

What I am hoping to do is send a copy of the report via excel week week and include any new information. I want to exclude any information that has already been sent to the recipient the week before.

I would be grateful for any help

Find more posts tagged with

Accepted answers

All comments

bisaacs

Hey @RosieB1763,

I would create a Filter View that is based on termination dates that are greater than the Saturday of last week. Then when you export to excel, it'll export the filtered view vs all sheets.

Hope this helps!

RosieB1763

Thanks a lot for your reply. I guess my only worry with that is if the termination date is 4 weeks in the future then it will appear on the weekly report multiple times

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.