Hi Matt,
No problem. You have excellently described the solution in your customary style. I am sure the community has become richer by one more option.
It is always interesting, how one problem can be solved in many ways. That is the beauty of logic and versatile platforms like AppSheet.