Question on ISTEXT and ISNONTEXT

[AuDHDtism]

Hi there.

My question is regarding is taxed and is non-taxed in the context of if you have a list of figures that you have filtered from other sheets and I would like the new list to be underneath whether or not there is text in the bath cell. My list is of daily and weekly chores which I've already been comprised and put together and will change if other tasks are included. I have worked it out so that it will put the new list of other chores underneath the daily and weekly chores in a specific date in a calendar set up. However, if I uncheck the daily and weekly calendar functionality. The new list still only goes down about eight rows when if the daily and weekly chores are not included, I'd like the other chores to be at the very top of the calendar. Space.

(GC-end of 2023)Cleaning Spreadsheet (Dec 1, 2023)_v3(AutoRecovered)(AutoRecovered).xlsx
	G
5	Nov 26
6	Jbedroom- Make Bed
7	Pets- Fill Water Bowl
8	Pets- Clean Litter
9	Pets- Feed Pets
10	Kitchen- Wipe counters
11	Kitchen- Empty Diswaher
12	Kitchen- Fill Diswasher
13	Pets- Empty/Fill Litter
14	Kitchen- Take out Trash/Recycling
15	Living- Organize
16
17
18
19
20
Monthly Calendar

Cell Formulas
Range	Formula
G5	G5	='Custmose Here'!C8
G6:G14	G6	=UNIQUE(IF(C6=TRUE,'Daily & Weekly Chores'!X5:X29&"- "&'Daily & Weekly Chores'!Y5:Y29,""),FALSE,TRUE)
G15	G15	=IFERROR(UNIQUE(IF(C7=TRUE,IF(AND(ISTEXT(G14)+ISNONTEXT(G14)),FILTER(B11:B40&"- "&C11:C40,D11#=G5),""),""),FALSE,TRUE),"")
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G5:M5,G21:M100,H6:M20	Expression	=TEXT(G5,"mmmm")<>$B$2	text	NO

(GC-end of 2023)Cleaning Spreadsheet (Dec 1, 2023)_v3(AutoRecovered)(AutoRecovered).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-end of 2023)Cleaning Spreadsheet (Dec 1, 2023)_v3(AutoRecovered)(AutoRecovered).xlsx
	B	C	D
11	Living	Organize	Sun, Nov 26
12	Bathroom	Organize	Sun, Dec 3
13	Office	Organize	Wed, Dec 6
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Monthly Calendar

Cell Formulas
Range	Formula
B11:C13	B11	=FILTER('Other Chores'!B5:C34,'Other Chores'!B5:B34<>"")
D11:D40	D11	=IF('Other Chores'!S5=TRUE,'Other Chores'!$BN$5:$BN$34,$BN$5<>"")
Dynamic array formulas.