Hello All,
need assistance finishing up a project for work efficiency. I crated a task management work sheet and would like to create a dashboard to summarize. The issue is that I want to display in a table the upcoming task due within a week. Let me see if I can describe it better. Sheet 2 has a table with task list and their corresponding due date. on sheet 1, in need to display the upcoming task that are upcoming due. the table in sheet 1 needs to have the ability to display however many task are coming due, regardless if its 1 or 20. here are the specifics, sheet 2 has a table. Column A2:A10 has the dates, B2:B:10 task tittle, C2:C10 Notes and columns D through G has information not needed on dashboard in sheet 1. For example, there are 8 total task but only 2 of them are due on this upcoming 7 days. hopefully this makes sense, let me know if I can provide more details.
need assistance finishing up a project for work efficiency. I crated a task management work sheet and would like to create a dashboard to summarize. The issue is that I want to display in a table the upcoming task due within a week. Let me see if I can describe it better. Sheet 2 has a table with task list and their corresponding due date. on sheet 1, in need to display the upcoming task that are upcoming due. the table in sheet 1 needs to have the ability to display however many task are coming due, regardless if its 1 or 20. here are the specifics, sheet 2 has a table. Column A2:A10 has the dates, B2:B:10 task tittle, C2:C10 Notes and columns D through G has information not needed on dashboard in sheet 1. For example, there are 8 total task but only 2 of them are due on this upcoming 7 days. hopefully this makes sense, let me know if I can provide more details.
