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
Answers
-
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!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives