Here’s an example that I have in a button in a document that opens a hidden view, opens a different document based on an ID, then goes back to the hidden view, closes it, and you’re viewing the document that you wanted to see.
If you want to stick to formulas, K O has a nice workaround, but if you want to use this as an opportunity to delve into LS, here are some suggestions.
If I understand you correctly, you are using a hidden view that you don’t need the user to interact with, as well as, move to the next doc [NavigateNext] and open it. Since this is activity that is going on the background, I would use LS. LS is great for doing things in the background.
OpenView in LS will be working on the front-end opening the view for the user. However, GetView will more work in the background, obtaining the view and other methods (GetFirstDocument, GetNextDocument) will allow you to navigate through the view in the background. Then the view isn’t really appearing and there isn’t the need to close it per se.