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?
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!