I don’t know if this is possible, or if there is a work around.
I have 12 columns (one for each month)
in each column I have an extensive formula calculation in which I need te refer to the month number.
Now I do this manually, but when I change the formula (doc still in building status) i have to think about the reference.
my current formula
If(thisRow.[end date]< Date(year,2 ,1 ),"" ,[Salery lines].filter(Employee=thisRow.employee and[salery date]<= EndOfMonth(Date(year,2,1),0)).jaarkost.last() )
and I need to fill the 2 for February
the formula is the same in each column, except for the month
I would love to name the column “2” and then refer the column name (this column.name)
Is this possible, or do I need to post this in suggustions
I need it in columns to be able to copy paste the data in a google sheet
Pieter