how to fill empty column based on act date

good evening,

I would like to be able, based on the month I am in, to feed the columns of the following months, based on how long a contract lasts.
ex:
it’s January, I have 3 months of contract and each month is worth 100, I would like it to feed the February, March and April column with 100.
another contract is worth 200 each month, and the contract expires in 5 months, so I need to feed equal amounts from February to June.
is there any way? i have created columns with value 1 with all the months i don’t know if it will help.

Can you share an example data set of your input and what the output should look like?

I feel like this goes into a direction that I have explored a fair bit and documented in an article on Medium that was published on Friday:

As well as in a video series on youtube…

Feel free to check out those resources (and sorry for shameless self-promotion :wink: ).

If you can share a data set (anonymised, but reflecting the general structure), I’d be happy to see if I can built a prototype.

4 Likes