VikingLink
New Member
- Joined
- Jun 18, 2022
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
I'd like to be able to create a to do list for our front desk, where the manager can create a to do list, and each employee can filter it to see only what they have to do.
When finishing a chore, they can tick it off, and that will then show in all tables. Should they need to pass a task on to another employee, they can also change that name. Deleting a row in a table would also be something they often do. All the tables should always automatically update if there is a change in either one of them.
I would put these tables on different sheets, but in the example below, I added them to the same one, just to make it visible.
At the top left you see the manager's table, so he/she has an overview of the entire day,the ones below are for two of the employees that they can filter.
To make it more complicated, I would need a master table for Monday, Tuesday, Wednesday, Thursday and Friday, and one for urgent tasks not linked to a specific day. All of these would be on separate sheets. These tables are displayed in my example starting at column G.
Each employee would have a sheet with their own name, and on those sheets the table would automatically display the data of the current day combined with the data of the urgent tasks.
Is this doable?
When finishing a chore, they can tick it off, and that will then show in all tables. Should they need to pass a task on to another employee, they can also change that name. Deleting a row in a table would also be something they often do. All the tables should always automatically update if there is a change in either one of them.
I would put these tables on different sheets, but in the example below, I added them to the same one, just to make it visible.
At the top left you see the manager's table, so he/she has an overview of the entire day,the ones below are for two of the employees that they can filter.
To make it more complicated, I would need a master table for Monday, Tuesday, Wednesday, Thursday and Friday, and one for urgent tasks not linked to a specific day. All of these would be on separate sheets. These tables are displayed in my example starting at column G.
Each employee would have a sheet with their own name, and on those sheets the table would automatically display the data of the current day combined with the data of the urgent tasks.
Is this doable?
Book1 | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | |||
1 | |||||||||||||||||||||||||||||||||
2 | Wednesday | Monday | Tuesday | Wednesday | Thursday | Friday | Urgent | ||||||||||||||||||||||||||
3 | Finished | Task | Responsible | Finished | Task | Responsible | Finished | Task | Responsible | Finished | Task | Responsible | Finished | Task | Responsible | Finished | Task | Responsible | Finished | Task | Responsible | ||||||||||||
4 | x | task 1 | Jolene | task a | Eddy | task a | Eddy | x | task 1 | Jolene | task a | Eddy | task a | Jolene | task a | Jolene | |||||||||||||||||
5 | task 2 | Eddy | task b | Eddy | task b | Eddy | task 2 | Eddy | task b | Eddy | task b | Jolene | task b | Eddy | |||||||||||||||||||
6 | task 3 | Jolene | task c | Jolene | task 3 | Jolene | task c | Eddy | task c | Jolene | task c | Jolene | |||||||||||||||||||||
7 | task a | Jolene | |||||||||||||||||||||||||||||||
8 | task b | Eddy | |||||||||||||||||||||||||||||||
9 | task c | Jolene | |||||||||||||||||||||||||||||||
10 | |||||||||||||||||||||||||||||||||
11 | Finished | Task | Responsible | ||||||||||||||||||||||||||||||
12 | x | task 1 | Jolene | ||||||||||||||||||||||||||||||
14 | task 3 | Jolene | |||||||||||||||||||||||||||||||
15 | task a | Jolene | |||||||||||||||||||||||||||||||
16 | task c | Jolene | |||||||||||||||||||||||||||||||
17 | |||||||||||||||||||||||||||||||||
18 | |||||||||||||||||||||||||||||||||
19 | Finished | Task | Responsible | ||||||||||||||||||||||||||||||
21 | task 2 | Eddy | |||||||||||||||||||||||||||||||
23 | task b | Eddy | |||||||||||||||||||||||||||||||
24 | |||||||||||||||||||||||||||||||||
25 | |||||||||||||||||||||||||||||||||
26 | |||||||||||||||||||||||||||||||||
27 | |||||||||||||||||||||||||||||||||
OriginalTable |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
O4:Q6 | Expression | =$B4="x" | text | NO |
B20:D23 | Expression | =$B4="x" | text | NO |
B12:D16 | Expression | =$B4="x" | text | NO |
B4:D9 | Expression | =$B4="x" | text | NO |