Hi everyone!
I'm trying to organize my sales data in my Airtable base.
I add the data through CSV upload. For every day of sales I add I add a new column to my sales data table.
Now I want to run automatic calculations on the data. To give an example: if sales for a particular product are decreasing for a few days in a row I want to make this visible in Airtable, or automatically send an email as a warning.
Now the problem is that if you create calculations to do this you do that for the existing columns, but every day I'm adding a new column to the table, so than the calculation won't include the newest data.
Does anyone know how to deal with this?
