Your requests log should keep closed work for reference. Put a live view of open work beside it.

Match the status column to the returned rows

Put ID, Status, and Item in A1:C1. Add R-1 / Open / Signs, R-2 / Closed / Keys, R-3 / Open / Lights, and R-4 / Closed / Chairs. Copy the headers to E1:G1. In an editor with dynamic arrays, use this in E2.

=FILTER(A2:C5,B2:B5="Open","No open requests")

The result should contain the full rows for R-1 and R-3.

The view returns the complete rows for R-1 and R-3.

Illustrated FILTER result. Keep the source status and data ranges aligned.

Close the last request in a copy

Set R-1 to Closed and expect R-3 alone. Close R-3 and expect No open requests. If the result cannot expand, clear the intended output cells or choose an empty destination. Extend both input ranges together when appending records. Save and reopen to verify the view recalculates in the receiving editor.

Closing the last open item produces No open requests.

Illustrated empty state. Edit the source log to update the view.

Microsoft’s FILTER function reference