Not sure if this belongs in automations or airtable.
I want to create an automation which creates a new entry in a separate spreadsheet which is being used to track spend for inventory in my business.
Ideally it creates a new entry, one for each week.
When a new item is added to the main buying spreadsheet, the cost of that is taken by the automation and added onto the spend for that week. Even better if it can take it away from the spend if a refund/return is taking place.
Is this possible? Sounds quite simple. If anyone can give me some advice where to start to build this, I would greatly appreciate it.