I work at an Ad Agency and we use Airtable as a project management tool between all of our clients and creators. We specifically track each concept we are working on in a single row. We charge clients against a monthly hourly allotment of 30 hours per month. We are looking for an easier/ better way to track monthly hours per project per client.
Some projects hop month to month and a designer may spend 5 hours in January and 6 hours in February. We need a way to track these hours in each month for each concept. Currently, we have 12 columns, one for each month of the year, for the designer to put the hours used per month per project. Some projects only last 1-3 months so it is kind of redundant to have so many collums.
Ideally, I want one column that can allow a designer to input their total hours per month as needed vs 12 different collums