Hi,

I am trying to get my financials done with Airtable so I can have a nice play field to test Airtable in real world conditions.

I created a first table for the acquisition from my bank.

So I have many columns, but specially I created a formula to format the date into MM-YYYY (ex: 04-2022)

Then, in a new table, I would like, for each row (04-2022 ; 05-2022…etc) to sum all the expenses and incomes for that specific month.

I know I can create a link to cell everytime (by converting a formula MM-YYYY to a link to cell), but I want to create it automatically so I don’t have to manually link every item.

I would like to replicate dynamically this :

Here are my data table :

Thank you !