I am trying to understand the formula in the “Cat Line” column of the Yearly Budget tab within the Foundations Template. Specifically, my question is why the formula in this column checks if the Type = “Income”. It is not clear to me why this is relevant, but when trying to replicate with a new sample list, I cannot make it work.

Full disclosure, this is out of pure curiosity on how to dynamically create a list that is grouped/categorized. If Tiller is not interested in explaining their formula, that is okay - just let me know.

Edit: I am asking about the formula for **Excel.** In the Foundations Template it is column AT (hidden by default).

Thanks.