Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 18, 2023 07:10 PM
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
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 18, 2023 07:54 PM
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
