Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to add the amount of times each product has sold

62 1
Showing results for 
Search instead for 
Did you mean: 

I have my inventory list on one table. I have another table where I enter the date a product has sold and how many units it sold on that date. I would like add the amount of times each product has sold within the last 30 60 & 90 days on my main table. Is there a good way to do this?

1 Reply 1

Yeah, here's a base with that set up.

The idea is to create a formula field that calculates the number of days since the sale, and then use conditonal rollups.  You should be able to see all the formulas if you duplicate the base

Screenshot 2023-01-19 at 11.52.49 AM.png

Screenshot 2023-01-19 at 11.52.45 AM.png