column info: show child row information i

	update	index	id	title	hidden	type	version	formula	width	validation	locked	options	description	symbol	systemColumnType	autoNumberFormat	contactOptions	format	lockedForUser	tags	'formula
	Collaboration powered by Smartsheet   |   Report Abuse
1		0	4907639619145604	RS Summ		CHECKBOX	0	=IF(AND(COUNT(CHILDREN()) > 0, NOT(ISBLANK([Resource's Manager]@row))), 1, 0)	44	False											'=IF(AND(COUNT(CHILDREN()) > 0, NOT(ISBLANK([Resource's Manager]@row))), 1, 0)
2		1	2655839805460356	Send		CHECKBOX	0		44	False											'
3		2	7159439432830852	Resource's Role		TEXT_NUMBER	0		113	False	True								False		'
4		3	1529939898617732	Assign Summary		TEXT_NUMBER	0	=IF([RS Summ]@row, JOIN([RS1]@row:[RS20]@row, CHAR(10) + CHAR(10)))	100	False	True								False		'=IF([RS Summ]@row, JOIN([RS1]@row:[RS20]@row, CHAR(10) + CHAR(10)))
5		4	6033539525988228	Resource Summary		TEXT_NUMBER	0	=IF([RS Summ]@row, "", IF(NOT(ISBLANK([Assigned To]@row)), Area@row + ": " + [Weekly Effort]@row + " h/w " + [% Allocation]@row * 100 + "% " + DATEONLY([Forecasted Start Date]@row) + "~" + DATEONLY([Forecasted End Date]@row), ""))	75	False	True								False	['GANTT_DISPLAY_LABEL']	'=IF([RS Summ]@row, "", IF(NOT(ISBLANK([Assigned To]@row)), Area@row + ": " + [Weekly Effort]@row + " h/w " + [% Allocation]@row * 100 + "% " + DATEONLY([Forecasted Start Date]@row) + "~" + DATEONLY([Forecasted End Date]@row), ""))
6		5	3781739712302980	Distinct Assigned		TEXT_NUMBER	0	=IF([RS Summ]@row, COUNT(DISTINCT(CHILDREN([Assigned To]@row))))	62	False	True								False		'=IF([RS Summ]@row, COUNT(DISTINCT(CHILDREN([Assigned To]@row))))
7		6	8285339339673476	Assigned To		CONTACT_LIST	0		73	False											'
8		7	966989945196420	CAN / US	True	PICKLIST	0		52	False	True	['US']							False		'
9		8	5470589572566916	% Allocation	True	TEXT_NUMBER	0		82	False	True								False		'
10		9	3218789758881668	Weekly Effort	True	TEXT_NUMBER	0		72	False	True								False		'
11		10	7722389386252164	Area		TEXT_NUMBER	0		97	False	True								False		'
12		11	2092889852039044	Forecasted Start Date	True	ABSTRACT_DATETIME	0		85	False	True								False	['GANTT_START_DATE']	'
13		12	6596489479409540	Forecasted End Date	True	ABSTRACT_DATETIME	0		85	False	True								False	['GANTT_END_DATE']	'
14		13	4344689665724292	Duration	True	DURATION	0		85	False	True								False	['GANTT_DURATION']	'
15		14	2185145749557124	Predecessors	True	PREDECESSOR	0		150	False										['GANTT_PREDECESSOR']	'
16		15	8848289293094788	Resource's Manager		CONTACT_LIST	0		76	False							[{'name': 'Shonda Connor'}]				'
17		16	263302503419780	Resource's Confirmation		PICKLIST	0		71	False	True	['Submitted', 'Approved', 'Declined']							False		'
18		17	4766902130790276	Manager's Approval	True	TEXT_NUMBER	0		85	False											'
19		18	3819790975061892	RS1		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 1, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 1)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 1)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 1, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 1)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 1)), CHAR(10)))
20		19	8323390602432388	RS2		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 2, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 2)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 2)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 2, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 2)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 2)), CHAR(10)))
21		20	1005041207955332	RS3		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 3, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 3)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 3)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 3, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 3)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 3)), CHAR(10)))
22		21	5508640835325828	RS4		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 4, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 4)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 4)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 4, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 4)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 4)), CHAR(10)))
23		22	3256841021640580	RS5		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 5, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 5)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 5)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 5, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 5)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 5)), CHAR(10)))
24		23	7760440649011076	RS6		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 6, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 6)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 6)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 6, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 6)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 6)), CHAR(10)))
25		24	2130941114797956	RS7		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 7, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 7)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 7)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 7, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 7)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 7)), CHAR(10)))
26		25	6634540742168452	RS8		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 8, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 8)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 8)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 8, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 8)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 8)), CHAR(10)))
27		26	4382740928483204	RS9		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 9, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 9)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 9)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 9, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 9)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 9)), CHAR(10)))
28		27	8886340555853700	RS10		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 10, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 10)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 10)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 10, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 10)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 10)), CHAR(10)))
29		28	90247533645700	RS11		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 11, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 11)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 11)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 11, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 11)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 11)), CHAR(10)))
30		29	4593847161016196	RS12		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 12, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 12)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 12)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 12, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 12)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 12)), CHAR(10)))
31		30	2342047347330948	RS13		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 13, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 13)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 13)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 13, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 13)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 13)), CHAR(10)))
32		31	6845646974701444	RS14		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 14, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 14)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 14)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 14, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 14)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 14)), CHAR(10)))
33		32	1216147440488324	RS15		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 15, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 15)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 15)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 15, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 15)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 15)), CHAR(10)))
34		33	5719747067858820	RS16		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 16, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 16)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 16)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 16, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 16)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 16)), CHAR(10)))
35		34	3467947254173572	RS17		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 17, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 17)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 17)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 17, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 17)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 17)), CHAR(10)))
36		35	7971546881544068	RS18		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 18, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 18)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 18)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 18, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 18)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 18)), CHAR(10)))
37		36	653197487067012	RS19		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 19, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 19)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 19)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 19, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 19)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 19)), CHAR(10)))
38		37	5156797114437508	RS20		TEXT_NUMBER	0	=IF([Distinct Assigned]@row >= 20, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 20)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 20)), CHAR(10)))	50	False											'=IF([Distinct Assigned]@row >= 20, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 20)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 20)), CHAR(10)))