The below is a formula that will determine the correct expense account, based on the description in the bank account. There is a helper table, where the description is stored and mapped to an expense account. In the bank download file this formula then goes through the helper table, looking for the description.
I have two questions:
- The out put of the formula is a list, with maybe a found value, somewhere in the list. How do I select only the item that is non-blank. Every idea I come up with is based on foreach(), which will just give another list.
- I used containstext() with the idea that I can put a portion of the description in the helper file. However, Coda does an exact match. Therefor entering “Brighthouse” will not work, I need to have the full, exact description in the table column.
If needed, I will do an example when it is not Friday…
Thank you very much.