Auto update rollup formula conditions

[Kevin_Humphreys]

I have a rollup field that calculates the amount of items that have sold in a specific month for each sku. I want that month to update with each month.

I have a SKU table that is connected to a SALES table. Below is what the rollup currently looks like. I want the Month-Year to autoupdate

I was thinking on building a script using automations where on the first of every month it would change the filter. Is this possible.

Side note: To me this is a countif formula, but I dont believe this has been implemented yet. It would be nice to see a feature that adds the ability to filter using a custom function

[TheTimeSavingCo]

Hey Kevin, if I were you I’d add another field in the Sales table to determine whether the sale was made that month, and then use that as the conditional to roll up on

Here’s an example

And here’s the formula used:

DATETIME_FORMAT(Date, "M YYYY") = DATETIME_FORMAT(TODAY(), "M YYYY")