It’s not quite as simple as it seems, but you can mostly replicate this. The thing I do like to remind people is that Airtable only looks like a spreadsheet, but it’s actually a database, so the structure underlying the template is what really needs to be worked on. That said, here’s a screenshot of something similar via a Timeline Interface view

This sample base is here, but inside a free workspace I can’t include a timeline interface, so I used a calendar (a little less ideal). 

Hm, could I confirm you already have a table where each record represents one of the days for that project and that’s how you’re assigning people to specific days?  If not that’s going to need to be the first step I’m afraid

You can set this up in Airtable by creating a projects table and a staff assignments table linked by date. Use a calendar or timeline view to show each project across the week, then assign different staff per day. This way, even long projects can display changing teams daily, similar to your Excel setup but more flexible.

Hm, could I confirm you already have a table where each record represents one of the days for that project and that’s how you’re assigning people to specific days?  If not that’s going to need to be the first step I’m afraid

Thanks, I was trying to avoid having to enter a different record for each day of the project, as I feel this would get overloaded in data pretty quickly, and be time consuming to enter in the first place, unless I am missing something (which I could well be!)

Thanks for the sample base

I get what you mean — creating a record for each day can feel heavy and time-consuming. But usually, that’s the cleanest way to manage assignments without things getting messy later. You might simplify it by using recurring records, copy/paste, or automations to reduce manual work, so it won’t feel as overloaded.