Is there a way to filter attachements based on date

gwson ✭✭✭✭✭

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.


  • Razetto
    Razetto ✭✭✭✭✭✭

    @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.

  • gwson
    gwson ✭✭✭✭✭
    edited 10/24/23

    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.

  • Tim C
    Tim C ✭✭✭✭✭
    edited 10/25/23


    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.