I’m a noob. I have 3 tables. Deductions, additions and then an overview table.
I’d like to add entries (in dollar amount) to deductions. I’d like to add entries (in dollar amount) to additions. And then finally make calculations in the overview table based off of the data from deductions and additions.
Is this possible? If so, what formulas do I use and where do I input them?
For example purposes,
Deductions table has:
Entry 1: -$7 Entry 2: -$10 Total: -$17
Additions table has:
Entry 1: $2 Entry 2: $5 Total: $7
Overview table has: Deductions: -$17 Additions: $7 Balance: -$10
Is this possible to create in app sheet?