▶️ Hierarchy Based Formulas: Parent % of Children

	Office	Correct/ Incorrect Product	Score	Score (no forced %)	Children
	Collaboration powered by Smartsheet   |   Report Abuse
1		Smartsheet Consulting Interest Form			0
2	Office		75%	0.75	20
3	Client #	Correct	1	1	0
4	Client #	Correct	1	1	0
5	Client #	Correct	1	1	0
6	Client #	Correct	1	1	0
7	Client #	Incorrect	0	0	0
8	Client #	Correct	1	1	0
9	Client #	Incorrect	0	0	0
10	Client #	Correct	1	1	0
11	Client #	Correct	1	1	0
12	Client #	Correct	1	1	0
13	Client #	Correct	1	1	0
14	Client #	Incorrect	0	0	0
15	Client #	Correct	1	1	0
16	Client #	Correct	1	1	0
17	Client #	Incorrect	0	0	0
18	Client #	Correct	1	1	0
19	Client #	Correct	1	1	0
20	Client #	Incorrect	0	0	0
21	Client #	Correct	1	1	0
22	Client #	Correct	1	1	0
23	Office 2		64%	0.63636	11
24	Client #	Incorrect	0	0	0
25	Client #	Correct	1	1	0
26	Client #	Correct	1	1	0
27	Client #	Correct	1	1	0
28	Client #	Incorrect	0	0	0
29	Client #	Correct	1	1	0
30	Client #	Incorrect	0	0	0
31	Client #	Correct	1	1	0
32	Client #	Correct	1	1	0
33	Client #	Correct	1	1	0
34	Client #	Incorrect	0	0	0
35	Office 3	Correct	50%	0.5	2
36	Client #	Correct	1	1	0
37	Client #	Incorrect	0	0	0
38	Office 4		n/a	n/a	4
39	Client #				0
40	Client #				0
41	Client #				0
42	Client #				0
43	Office 5		100%	1	1
44	Client 1	Correct	1	1	0