I’m making a simple budget, and I am used to using google sheets, where every cell can be a formula, so I’m trying to adapt to the Airtable way of thinking. How is Airtable meant to handle sub categories?
Please see attached image, my list on the left is the various forms of income. I want the “Total ticket income” cell to calculate an amount based on the variables to the right. The only way I could make a formula is to make an entire column for it.
But gow do I get the individual cell (highlighted in my image) to calculate those totals, without affecting the entire list of other amounts that arent relevant to it?