Test Area

	Primary Column	Milestone	Date	Column2	Column5
	Collaboration powered by Smartsheet   |   Report Abuse
1	Parent Task	C - Grabs this text because column2 is checked
2	Task 1	a	10/06/20
3	Task 2	b	10/15/20
4	Task 3	C - Grabs this text because column2 is checked			<-- Column 2 is checked because the formula checks a range for the first blank cell, in this case, it's checking rows 2 through 9, column2.
5	Task 4	d
6	Task 5	e	10/28/20
7	Task 6	f	10/21/20
8	Task 7	g
9	Task 8	h
10
11
12
13
14
15
16
17
18
19
20
21