Hi @Amanda_Garfunkel and welcome to the community!

If I understand your case correctly, you would have to create a record for each period (so every other week, or every 3 day time period) for the calendar view to show it correctly. Eg, by making a third table “planning”. The standard Airtable views doesn’t have any features to do this otherwise (maybe via scripting, but no expert on that).

Hi, @Databaser thank you for responding!

I’m not an expert on scripting either, so I’m in the same boat as you. I had created a separate table to dedicate to the calendar view and linked it with the projects table to import the project and begin and end dates. If you’re suggesting that/each day week needs its own record, I’m wondering if I should keep the table entirely separate? I’d have to manually put in all the dates/weeks, correct?

If you have a start and end date that form 1 periode, eg 17th/08 to 20th/08, you can show that on a calendar view and use colour conditions to show the project or the employee, … Or make 1 calendar view per employee.

Without scripting, I would keep a table for my projects and create a separate table for planning purposes and link those 2 together. That way, you could use rollup fields in your projects table for calculating hours, costs, … per project (if you need any of that of course). That means, like you said, that you would put in the time periods per employee per project manually. Unless the periods are alike, then you maybe could put something together with an automation (eg: a checkbox as trigger to create a new record for period x + y).

If you have a budget, you can always ask the many (scripting) experts here via the “hire a consultant” on this forum.