Flag removed projects from next cycle report.

Hello,

Each month (around 20th day of month) I am manually uploading the report to Projects table in Quickbase. Users can work on projects and modify them.
I would like to flag the projects which were in previous month report but are not in current month report.
For example in report from April I have projects with id 1, 2, 3 and I upload them to Projects table. In May my report contains project with id 3 only, so I upload this report and update the values for project 3. But I would also flag the projects 1 and 2 as removed. 

Do you have any idea, how can I automate this process in Quickbase?

------------------------------
Piotr Kryszkiewicz
------------------------------