Hi Crimson!
I found a solution and made a proof-of-concept, the blueprint of which is attached to this post. Figured I should share it this way, because it's a little too much to explain in text, or to sketch up as a wiring diagram. Check the BP in the game, and feel free to ask if the purpose...