Collective Checkbox based on cell entry

[Deepinmind]

I am trying to create two functions: one to detect if all checkboxes in rows that have an entry in the A column are checked, and then if they are, trigger a checkbox on the main tab to be checked in the corresponding row.

Here is the "Day" tab showing a generic example of entries and the checkboxes that need to be made true if the task has been entered:

I need employees to check these boxes when they have entered this data in our system
I want to create logic so that when all rows that DO have a description entered into Column A have been checked, it creates a "true" reference cell. We can ignore all rows that have a checkbox, but no entry in Column A.

I then want that true/false reference cell to cause a checkbox on the "totals" tab to be checked (made true) if the corresponding tab has a true reference cell:

I already have the cells corresponding to each tab (Column A) on this "Totals" tab linked to the current name of the corresponding tab (as shown in the formula for cell A22).

Is this possible, and, if so, what is the best method for doing this?
Any help is appreciated. Thanks!

 

[Deepinmind]

I am trying to create two functions: one to detect if all checkboxes in rows that have an entry in the A column are checked, and then if they are, trigger a checkbox on the TOTALS tab to be checked in the corresponding row.

Edit: for clarity on Thesis of Question

 

[Deepinmind]

Xl2bb minisheet. Sorry, for inserting this late. I just installed and learned how to use this. Haha

Days tab

2024 December.xlsb
	A	B	C	D	E	F	G	H	I	J	K
1	Description	EQ#	WO#	Hours	DONE?		Mon 02
2	FLOOR COVERAGE			1			Total	Total left until Net	Kronos	Net Hours
3	DC 2 LPAS LINE 2 PRINTER 1 LOSING TOP PART OF LABEL			1			11.5	0	12.25	11.5	-0.5
4	DC 2 LPAS LINE 2 PRINTER 2 LABELS WRAPPED AROUND PRESSURE ROLLER AND TAMP.			1.5
5	UPPER AND LOWER SCANNERS IN SB2 BAD READS			2
6	RESEARCH ON DELRIN ROLLERS FOR LPAS TAMPS			2
7	QUARTERLY PARTIAL PM OF ENCODERS	2-CO-S-323-1	24-051661	0.5					Kronos Entry
8	QUARTERLY PARTIAL PM OF ENCODERS	2-CO-S-323-14	24-051665	0.5					12.18
9	QUARTERLY PARTIAL PM OF ENCODERS	2-CO-S-323-15	24-051666	0.5
10	QUARTERLY PARTIAL PM OF ENCODERS	2-CO-S-323-16	24-051667	0.5
11	DC7 LPAS LINE 1 TAMPS PUSHING BOXES TOO HARD			2
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Mon 02

Cell Formulas
Range	Formula
G1	G1	=MID(CELL("filename",O1),FIND("]",CELL("filename",O1))+1,256)
G3	G3	=SUM(D2:D103)
H3	H3	=J3-G3
I3	I3	=MROUND(I8,0.25)
J3	J3	=(I3)-0.75

Totals Tab:

2024 December.xlsb
	A	B	C	D	E	F	G	H	I	J	K
1	Date	Daily Total Hours	NET Hours	DONE?
2	Mon 02	11.5	11.5
3	Tues 03	11.5	11.5
4	Weds 04	8.75	8.75
5	Thurs 05	7.75	7.75
6	Fri 06	8.25	8.25			Month Net Hours	Month Total	Kronos Total	Difference	Kronos/MP2
7	Mon 9	7.75	7.75			183	183	194.5	0	100.00%
8	Tues 10	7.75	7.75
9	Weds 11	7.5	7.5
10	Thurs 12	8.25	8.25
11	Fri 13	7.75	7.75
12	Mon 16	8.25	8.25					True Kronos
13	Tues 17	8.25	8.25					194.29
14	Wed 18	7.75	7.75
15	Thurs 19	8	8
16	Fri 20	7.75	7.75
17	Mon 23	11.75	11.75
18	Tues 24	8	8
19	Thurs 26	11.5	11.5
20	Fri 27	7.5	7.5
21	Mon 30	11.5	11.5
22	Tues 31	6	6
23	Mon 02 (22)	0	0
24	Mon 02 (23)	0	0
25	Mon 02 (24)	0	0
26	Mon 02 (25)	0	0
27	Mon 02 (26)	0	0
28	Mon 02 (27)	0	0
29	Mon 02 (28)	0	0
30	Mon 02 (29)	0	0
31	Mon 02 (30)	0	0
32	Mon 02 (31)	0	0
33
34
Totals

Cell Formulas
Range	Formula
A2	A2	='Mon 02'!G1
B2	B2	='Mon 02'!G3
C2	C2	=SUMIF('Mon 02'!J3,">0")
A3	A3	='Tues 03'!G1
B3	B3	='Tues 03'!G3
C3	C3	=SUMIF('Tues 03'!J3,">0")
A4	A4	='Weds 04'!G1
B4	B4	='Weds 04'!G3
C4	C4	=SUMIF('Weds 04'!J3,">0")
A5	A5	='Thurs 05'!G1
B5	B5	='Thurs 05'!G3
C5	C5	=SUMIF('Thurs 05'!J3,">0")
A6	A6	='Fri 06'!G1
B6	B6	='Fri 06'!G3
C6	C6	=SUMIF('Fri 06'!J3,">0")
A7	A7	='Mon 9'!G1
B7	B7	='Mon 9'!G3
C7	C7	=SUMIF('Mon 9'!J3,">0")
A8	A8	='Tues 10'!G1
B8	B8	='Tues 10'!G3
C8	C8	=SUMIF('Tues 10'!J3,">0")
A9	A9	='Weds 11'!G1
B9	B9	='Weds 11'!G3
C9	C9	=SUMIF('Weds 11'!J3,">0")
A10	A10	='Thurs 12'!G1
B10	B10	='Thurs 12'!G3
C10	C10	=SUMIF('Thurs 12'!J3,">0")
A11	A11	='Fri 13'!G1
B11	B11	='Fri 13'!G3
C11	C11	=SUMIF('Fri 13'!J3,">0")
A12	A12	='Mon 16'!G1
B12	B12	='Mon 16'!G3
C12	C12	=SUMIF('Mon 16'!J3,">0")
A13	A13	='Tues 17'!G1
B13	B13	='Tues 17'!G3
C13	C13	=SUMIF('Tues 17'!J3,">0")
A14	A14	='Wed 18'!G1
B14	B14	='Wed 18'!G3
C14	C14	=SUMIF('Wed 18'!J3,">0")
A15	A15	='Thurs 19'!G1
B15	B15	='Thurs 19'!G3
C15	C15	=SUMIF('Thurs 19'!J3,">0")
A16	A16	='Fri 20'!G1
B16	B16	='Fri 20'!G3
C16	C16	=SUMIF('Fri 20'!J3,">0")
A17	A17	='Mon 23'!G1
B17	B17	='Mon 23'!G3
C17	C17	=SUMIF('Mon 23'!J3,">0")
A18	A18	='Tues 24'!G1
B18	B18	='Tues 24'!G3
C18	C18	=SUMIF('Tues 24'!J3,">0")
A19	A19	='Thurs 26'!G1
B19	B19	='Thurs 26'!G3
C19	C19	=SUMIF('Thurs 26'!J3,">0")
A20	A20	='Fri 27'!G1
B20	B20	='Fri 27'!G3
C20	C20	=SUMIF('Fri 27'!J3,">0")
A21	A21	='Mon 30'!G1
B21	B21	='Mon 30'!G3
C21	C21	=SUMIF('Mon 30'!J3,">0")
A22	A22	='Tues 31'!G1
B22	B22	='Tues 31'!G3
C22	C22	=SUMIF('Tues 31'!J3,">0")
A23	A23	='Mon 02 (22)'!G1
B23	B23	='Mon 02 (22)'!G3
C23	C23	=SUMIF('Mon 02 (22)'!J3,">0")
A24	A24	='Mon 02 (23)'!G1
B24	B24	='Mon 02 (23)'!G3
C24	C24	=SUMIF('Mon 02 (23)'!J3,">0")
A25	A25	='Mon 02 (24)'!G1
B25	B25	='Mon 02 (24)'!G3
C25	C25	=SUMIF('Mon 02 (24)'!J3,">0")
A26	A26	='Mon 02 (25)'!G1
B26	B26	='Mon 02 (25)'!G3
C26	C26	=SUMIF('Mon 02 (25)'!J3,">0")
A27	A27	='Mon 02 (26)'!G1
B27	B27	='Mon 02 (26)'!G3
C27	C27	=SUMIF('Mon 02 (26)'!J3,">0")
A28	A28	='Mon 02 (27)'!G1
B28	B28	='Mon 02 (27)'!G3
C28	C28	=SUMIF('Mon 02 (27)'!J3,">0")
A29	A29	='Mon 02 (28)'!G1
B29	B29	='Mon 02 (28)'!G3
C29	C29	=SUMIF('Mon 02 (28)'!J3,">0")
A30	A30	='Mon 02 (29)'!G1
B30	B30	='Mon 02 (29)'!G3
C30	C30	=SUMIF('Mon 02 (29)'!J3,">0")
A31	A31	='Mon 02 (30)'!G1
B31	B31	='Mon 02 (30)'!G3
C31	C31	=SUMIF('Mon 02 (30)'!J3,">0")
A32	A32	='Mon 02 (31)'!G1
B32	B32	='Mon 02 (31)'!G3
C32	C32	=SUMIF('Mon 02 (31)'!J3,">0")
F7	F7	=SUM(C2:C32)
G7	G7	=SUM('Mon 02:Mon 02 (31)'!G3)
H7	H7	=SUM('Mon 02:Mon 02 (31)'!I3)
I7	I7	=G7-F7
J7	J7	=IFERROR((G7/F7)*1,"---")
H13	H13	=SUM('Mon 02:Mon 02 (31)'!I8)