Auto-populating rows in a table based on formula

Hey all.

I’m not sure if this is even possible, but probably I just don’t get it mentally.

I have a daily journal table which has rows for every single day (which get populated by an automation).
There’s a column “Month” which calculates the actual month using this formula:

Would it be possible to populate a separate table with any new return (i.e. monthly) of the above formula as display column as shown below?

Bildschirmfoto 2021-06-21 um 22.05.07

There’s no big hassle to add the rows manually, I am just interested if this would be possible automatically.

Thanks for any hints or advice!

1 Like