I have a budgeting app all set up. On the right in blue I have a nested group-by setup working flawlessly. I can see all the items I have not categorized yet in the blank category grouping. Perfection. On the left in red I did the same setup. Except ...

In my budget app, when I want to add a new transaction I'm getting inconsistent behavior utilizing formula using data in the row I'm adding.Scenario 1 : I use ACCOUNT NAME to automatically search and set ACCOUNT ID and ACCOUNT # automatically from a ...