LLMs can be super helpful in puzzling through tricky problems, but just keep in mind that while you might be solving the more immediate tactical problem, you could be painting yourself into a corner strategically! I've seen a lot of Airtable formulas...

Full disclosure - since I don't have the context for what you're trying to achieve, and I can't quite get my head around the formula logic, I just pasted your whole question into Gemini. So while I tested the output and see that it's working, I can't...

Oops, yep I missed that!