Is there a way to filter attachements based on date
Pretty much looking to create a report that provides a curated view that filters out attachments that have been uploaded/modified within the last year.
Answers
-
@gwson There is none but I think that you could add a new date column to your sheet and set an automation to record the date whenever an attachment is added or changed. Then that column can be use in your report to filter out attachments outside your date range.
-
Good thinking, but unfortunately this will not work for me since we only add attachments to existing rows (no new rows). I would just need to show say latest 10 attachments after certain date from one row.
-
You could have a separate sheet and a copy row automation with a "modified date" system column and trigger a copy row anytime the new attachment is added. You would capture the day and time it was copied.
If each row had a unique ID you could then make a grouped report to pull all of the same rows back together.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives