Form Submission Filtering

Hey everyone I have a problem that I am not sure is solvable.

My base is set up to track my teams High Level Goals then the Projects Associated with those and the deliverables that make up those projects.

I have a form that my team fills out weekly to give me their project status updates. I then rollup those updates to the Goal so I can see how each project is progressing in one view.

The issue I am having is that while most projects progress with updates each week I also have ones that may have the same status for a few weeks where a new submission won’t be added.

How do I do one of the following:

  1. Make the roll up point to a view that only takes the most recent update in each project even if it is old.

  2. Make a view on the table that copies the previous update into a new entry if nothing is submitted so I can have a view that filters by the date they are required to be submitted and use that for my roll up.