Task Management spreadsheet. How to create a column where i can assign the task to several people (not just one)

[davids4500]

I have a task management spreadsheet and would like to assign some tasks to several people, not just one. The column is H. How do i go about accomplishing that?

TaskSheetCLCSierraLeone2025BackUp.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		ACTION ITEMS
2							Last Updated:		8/01/2025			Next Meeting:	Wed, 8-Jan-2025, 8:00 PM
3	TASK ITEM	ACTION ITEM	RANK	PRIORITY	Difficulty	Expense Level	OWNER	Task Assigned To	ASSIGNED	DUE	DONE	STATUS	NOTES	Notes From Each Person	Column1
4	Task 1	Prices		HIGH	LOW	LOW	David	George	8/01/2025	8/01/2025		Pending
5	Task 2	Generator		HIGH	MEDIUM	HIGH	David	Alfred	8/01/2025	10/01/2025		Pending
6	Task 3	Purchase order		HIGH	LOW	MEDIUM	David	Amara	8/01/2025	10/01/2025		25%
7	Task 4	Repair Wall around Head office		HIGH	HIGH	HIGH	David	Alfred	8/01/2025			Not Started
8	Task 5	New Worker		HIGH	HIGH	LOW	David	Alfred	8/01/2025	1/02/2025		Pending
9	Task 6	Trip for		HIGH		HIGH						Pending
10	Task 7	books		MEDIUM	LOW	LOW	David	Alfred	8/01/2025	10/01/2022		25%
11	Task 8	ordering		MEDIUM	LOW	LOW	David	Amara	8/01/2025	10/01/2025		25%
12	Task 9	water tanks		MEDIUM	LOW	MEDIUM	David	Alfred	8/01/2025	13/01/2022		75%
13	Task 10	Painting of head Office		MEDIUM	HIGH	HIGH	David	Alfred	8/01/2025			Not Started
14	Task 11	Glass Doors For Bo		MEDIUM	MEDIUM	MEDIUM	Matthew	Alfred	8/01/2025	15/01/2025		Pending
15	Task 12	Amara's Finance Course		MEDIUM	LOW	LOW	David	AMara	8/01/2025	15/01/2025		100%
16	Task 13	sign		HIGH	MEDIUM	LOW	David	Alfred	8/01/2025			Pending
17	Task 14	rent		MEDIUM	LOW	HIGH	David		8/01/2025			Pending
18	Task 15	staffing		LOW	LOW	LOW	David	Alfred	8/01/2025			25%
19	Task 16	roof repair		HIGH	HIGH	HIGH	David		8/01/2025			Not Started
20	Task 17	painting		HIGH	HIGH	HIGH	David		8/01/2025			Not Started
21	Task 18	music		MEDIUM	MEDIUM	HIGH	David		8/01/2025			25%
ActionItems

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C4:M10,A4:A87,B11:M24	Expression	=($K4="√")	text	YES
C4:C24	Other Type	Icon set		NO
D4:F24	Cell Value	contains "LOW"	text	NO
D4:F24	Cell Value	contains "MEDIUM"	text	NO
D4:F24	Cell Value	contains "HIGH"	text	NO
L4:L24	Other Type	DataBar		NO
K4:K24	Other Type	Icon set		NO

Cells with Data Validation
Cell	Allow	Criteria
K4:K24	List	√
L4:L24	List	Not Started,25%,50%,75%,100%,On Hold,Pending
C4:C24	List	5,4,3,2,1
D4:F24	List	HIGH,MEDIUM,LOW

 

[HighAndWilder]

I have a task management spreadsheet and would like to assign some tasks to several people, not just one. The column is H. How do i go about accomplishing that?

TaskSheetCLCSierraLeone2025BackUp.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		ACTION ITEMS
2							Last Updated:		8/01/2025			Next Meeting:	Wed, 8-Jan-2025, 8:00 PM
3	TASK ITEM	ACTION ITEM	RANK	PRIORITY	Difficulty	Expense Level	OWNER	Task Assigned To	ASSIGNED	DUE	DONE	STATUS	NOTES	Notes From Each Person	Column1
4	Task 1	Prices		HIGH	LOW	LOW	David	George	8/01/2025	8/01/2025		Pending
5	Task 2	Generator		HIGH	MEDIUM	HIGH	David	Alfred	8/01/2025	10/01/2025		Pending
6	Task 3	Purchase order		HIGH	LOW	MEDIUM	David	Amara	8/01/2025	10/01/2025		25%
7	Task 4	Repair Wall around Head office		HIGH	HIGH	HIGH	David	Alfred	8/01/2025			Not Started
8	Task 5	New Worker		HIGH	HIGH	LOW	David	Alfred	8/01/2025	1/02/2025		Pending
9	Task 6	Trip for		HIGH		HIGH						Pending
10	Task 7	books		MEDIUM	LOW	LOW	David	Alfred	8/01/2025	10/01/2022		25%
11	Task 8	ordering		MEDIUM	LOW	LOW	David	Amara	8/01/2025	10/01/2025		25%
12	Task 9	water tanks		MEDIUM	LOW	MEDIUM	David	Alfred	8/01/2025	13/01/2022		75%
13	Task 10	Painting of head Office		MEDIUM	HIGH	HIGH	David	Alfred	8/01/2025			Not Started
14	Task 11	Glass Doors For Bo		MEDIUM	MEDIUM	MEDIUM	Matthew	Alfred	8/01/2025	15/01/2025		Pending
15	Task 12	Amara's Finance Course		MEDIUM	LOW	LOW	David	AMara	8/01/2025	15/01/2025		100%
16	Task 13	sign		HIGH	MEDIUM	LOW	David	Alfred	8/01/2025			Pending
17	Task 14	rent		MEDIUM	LOW	HIGH	David		8/01/2025			Pending
18	Task 15	staffing		LOW	LOW	LOW	David	Alfred	8/01/2025			25%
19	Task 16	roof repair		HIGH	HIGH	HIGH	David		8/01/2025			Not Started
20	Task 17	painting		HIGH	HIGH	HIGH	David		8/01/2025			Not Started
21	Task 18	music		MEDIUM	MEDIUM	HIGH	David		8/01/2025			25%
ActionItems

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C4:M10,A4:A87,B11:M24	Expression	=($K4="√")	text	YES
C4:C24	Other Type	Icon set		NO
D4:F24	Cell Value	contains "LOW"	text	NO
D4:F24	Cell Value	contains "MEDIUM"	text	NO
D4:F24	Cell Value	contains "HIGH"	text	NO
L4:L24	Other Type	DataBar		NO
K4:K24	Other Type	Icon set		NO

Cells with Data Validation
Cell	Allow	Criteria
K4:K24	List	√
L4:L24	List	Not Started,25%,50%,75%,100%,On Hold,Pending
C4:C24	List	5,4,3,2,1
D4:F24	List	HIGH,MEDIUM,LOW

Ideally you need a seperate table as you have a one to many relationship that you need to represent.

VBA - Copying Non-Contiguous Ranges.xlsm
	A	B
1	TASK ITEM	Task Assigned To
2	Task 1	George
3	Task 1	Alfred
4	Task 1	Amara
5	Task 2	Alfred
6	Task 2	Fred
Assignments

VBA - Copying Non-Contiguous Ranges.xlsm
	H
2
3	Task Assigned To
4	George, Alfred, Amara
5	Alfred, Fred
6
7
8
9
10
11
12
ActionItems

Cell Formulas
Range	Formula
H4:H12	H4	=IFERROR(TEXTJOIN(", ",TRUE,CHOOSECOLS(FILTER(tblAssignments,tblAssignments[TASK ITEM]=ActionItems!A4,""),2)),"")

 

[HighAndWilder]

Ideally you need a seperate table as you have a one to many relationship that you need to represent.

VBA - Copying Non-Contiguous Ranges.xlsm
	A	B
1	TASK ITEM	Task Assigned To
2	Task 1	George
3	Task 1	Alfred
4	Task 1	Amara
5	Task 2	Alfred
6	Task 2	Fred
Assignments

VBA - Copying Non-Contiguous Ranges.xlsm
	H
2
3	Task Assigned To
4	George, Alfred, Amara
5	Alfred, Fred
6
7
8
9
10
11
12
ActionItems

Cell Formulas
Range	Formula
H4:H12	H4	=IFERROR(TEXTJOIN(", ",TRUE,CHOOSECOLS(FILTER(tblAssignments,tblAssignments[TASK ITEM]=ActionItems!A4,""),2)),"")

The same approcah can be used for the Notes.

VBA - Copying Non-Contiguous Ranges.xlsm
	A	B	C
1	TASK ITEM	Task Assigned To	Note
2	Task 1	George	Task 1 note from George
3	Task 1	Alfred	Task 1 note from Alfred
4	Task 1	Amara	Task 1 note from Amara
5	Task 2	Alfred	Task 2 note from Alfred
6	Task 2	Fred	Task 2 note from Fred
Notes

Cell Formulas
Range	Formula
C2:C6	C2	=[@[TASK ITEM]] & " note from " & [@[Task Assigned To]]

VBA - Copying Non-Contiguous Ranges.xlsm
	N
2
3	Notes From Each Person
4	Task 1 note from George Task 1 note from Alfred Task 1 note from Amara
5	Task 2 note from Alfred Task 2 note from Fred
6
7
8
9
ActionItems

Cell Formulas
Range	Formula
N4:N6	N4	=IFERROR(TEXTJOIN(CHAR(10),TRUE,FILTER(tblNotes[Note],tblNotes[TASK ITEM]=A4)),"")