Populate List Based on Date and Crew Number

e_filippo 

It sounds like you are on the right track using functions like INDEX/MATCH or XLOOKUP to pull tasks from the main "Task List" sheet to each crew's task list sheet based on crew number and due date. Here's a possible approach you could try:

1. In each crew's task list sheet, create a table with columns for the task name, due date, and crew number.
2. In the "Task List" sheet, add a column for crew number and fill in the crew number for each task.
3. Use the INDEX/MATCH or XLOOKUP function to pull tasks from the "Task List" sheet to each crew's task list sheet based on the crew number and due date. For example, you could use a formula like this to pull tasks for Crew 1 that are due today:

=IFERROR(INDEX('Task List'!$A$2:$C$100,MATCH(1,('Task List'!$B$2:$B$100=TODAY())*('Task List'!$C$2:$C$100=1),0),1),"")

This formula uses the MATCH function to find the row in the "Task List" sheet where the due date matches today's date and the crew number matches 1 (for Crew 1). It then uses the INDEX function to pull the task name from column A of that row. If no match is found, the formula returns an empty string.

1. Repeat step 3 for each crew and each day.

Note that this approach assumes that each task has a single due date and crew number. If tasks can have multiple due dates or be assigned to multiple crews, you may need to modify the approach accordingly.

I hope this helps!