Help tweeking a Vstack and Filter formula

[AuDHDtism]

Hello everyone,

I need assistance for tweaking a V stock in filter formula. My main concern is that I end up with a lot of rose underneath the data as it is stocked. I am wondering/hoping if someone were able to look at the formula and let me know what I've done incorrectly or if I can have an answer to this question. I know if you're doing a V stack formula in order to home not have blank excessive rows underneath you wrap it in a filter function. However, I have tried this numerous times and it is not working so I'm hoping that posting here someone will be able to help me.

(GC)Cleaning Spreadsheet (Dec 1, 2023)_v3.xlsx
	W	X	Y	Z
2	Sunday
3
4		Area	Chore	Time
5		Jbedroom	Make Bed	8:00:00 AM
6		Pets	Fill Water Bowl	8:10:00 AM
7		Pets	Clean Litter	8:20:00 AM
8		Pets	Feed Pets	8:30:00 AM
9		Kitchen	Wipe counters	8:45:00 AM
10		Kitchen	Empty Diswaher	9:00:00 AM
11		Kitchen	Fill Diswasher	9:00:00 AM
12		Pets	Empty/Fill Litter
13		Kitchen	Take out Trash/Recycling
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Daily & Weekly Chores

Cell Formulas
Range	Formula
X5:Z13	X5	=IF(VSTACK(FILTER($B$5:$D$29,$B$5:$B$29<>""),FILTER($F$5:$H$29,J$5:$J$29=TRUE))=0,"",VSTACK(FILTER($B$5:$D$29,$B$5:$B$29<>""),FILTER($F$5:$H$29,J$5:J$29=TRUE)))
Dynamic array formulas.

(GC)Cleaning Spreadsheet (Dec 1, 2023)_v3.xlsx
	T	U	V
6	Jbedroom	Make Bed	8:00
7	Pets	Fill Water Bowl	8:10
8	Pets	Clean Litter	8:20
9	Pets	Feed Pets	8:30
10	Kitchen	Wipe counters	8:45
11	Kitchen	Empty Diswaher	9:00
12	Kitchen	Fill Diswasher	9:00
13	Pets	Empty/Fill Litter
14	Kitchen	Take out Trash/Recycling
15	Living	Organize
16	Bathroom	Organize
17	FALSE	FALSE
18	FALSE	FALSE
19	FALSE	FALSE
20	FALSE	FALSE
21	FALSE	FALSE
22	FALSE	FALSE
23	FALSE	FALSE
24	FALSE	FALSE
25	FALSE	FALSE
26	FALSE	FALSE
27	FALSE	FALSE
28	FALSE	FALSE
29	FALSE	FALSE
30	FALSE	FALSE
31	FALSE	FALSE
32	FALSE	FALSE
33	FALSE	FALSE
34	FALSE	FALSE
35	FALSE	FALSE
36	FALSE	FALSE
37	FALSE	FALSE
38	FALSE	FALSE
39	FALSE	FALSE
40	FALSE	FALSE
41	FALSE	FALSE
42	FALSE	FALSE
43	FALSE	FALSE
44	FALSE	FALSE
Monthly Calendar

Cell Formulas
Range	Formula
T6:V45	T6	=IFERROR(VSTACK(FILTER('Daily & Weekly Chores'!X5:Z29,'Daily & Weekly Chores'!X5:X29<>"",""),IF(S2=D11:D40,FILTER(B11:C40,B11:B40<>"")),""),"")
Dynamic array formulas.

(GC)Cleaning Spreadsheet (Dec 1, 2023)_v3.xlsx
	T
6	Jbedroom
Monthly Calendar

Cell Formulas
Range	Formula
T6:V45	T6	=IFERROR(VSTACK(FILTER('Daily & Weekly Chores'!X5:Z29,'Daily & Weekly Chores'!X5:X29<>"",""),IF(S2=D11:D40,FILTER(B11:C40,B11:B40<>"")),""),"")
Dynamic array formulas.

 

[StephenCrump]

You've posted two different formulae, both of which refer to other cells in your workbook which we can't see. So it's not clear what results you're expecting to see, or what you mean by "incorrectly" and "not working"?

Your first formula can be written more simply:

=LET(v,VSTACK(FILTER($B$5:$D$29,$B$5:$B$29<>""),FILTER($F$5:$H$29,J$5:$J$29=TRUE)),IF(v=0,"",v))

Is your first formula (or this simpler version) producing blank rows? The only way I can see this happening is if you have TRUE in column J, and the corresponding values in F:H are all blank?