Filter in Google Sheets not working within IF statement mismatched range sizes
I am receiving the following error:
FILTER has mismatched range sizes. Expected row count: 1759. column count: 1. Actual row count: 1, column count: 1.
The function in question is:
=IF(F2="",
"Please enter a year",
IF(F4="",
IF(F6="",
{"Same filter that built SrcTbl"},
FILTER(SrcTbl,SrcCat=F6)),
IF(F6="",
FILTER(SrcTbl,MONTH(SrcDates)=MONTH(F4&1)),
FILTER(SrcTbl,MONTH(SrcDates)=MONTH(F4&1),SrcCat=F6))))
SrcCat is a column within SrcTbl (e.g. A:A vs. A:C). The cells being checked contain a Year, a Month (or no month), and a Category (or no category). All of the filter functions work properly on their own, provided the respective cells are populated, and the function works properly if I replace the faulty filters (both containing SrcCat=F6) with a text string. It is only when a value is placed in F6 that the nested filters return this error.
Why do these filters work on their own, but not when inside this function?
Solution
instead of your:
={FILTER(CData, YEAR(CDates) =B1);
FILTER(SData, YEAR(SDates) =B1);
FILTER(CrData, YEAR(CrDates)=B1)}
you can do just:
=FILTER({CData; SData; CrData}, YEAR({CDates; SDates; CrDates})=B1)
now what went wrong:
- How to combine multiple conditions in a PowerShell if-statement
- I get an error when I end the if statement with a concluding else statement
- Does PHP have short-circuit evaluation?
- Why is this code still adding 1 to i even when the if statment that does so isnt called in C?
- error compiling in c user input
- R Conditional IfElse With Random Values
- Can not get past illogical line pep8 error
- smarty help with if statement
- 'if' must have both main and 'else' branches if used as an expression
- What is the standard for choosing "when" vs "if/else" in Kotlin?
- Python script continuously repeats the first if - else statement
- Why does python use 'else' after for and while loops?
- Use of ternary operator instead of if-else in C++
- Evaluate boolean environment variable in Python
- How to use if/else statement in terraform for loop
- change number grade to letter grade
- How to debug this substring matching code?
- If condition is getting skipped even if the condition is true
- Assign value to all rows based on condition being fulfilled or not
- Looping through a list in Python
- Why does if (fork() || fork() || fork()) behave differently?
- Python if not == vs if !=
- Discord.py | If statement not working correctly
- Angular 17 - In @if syntax, how to store returned value from a function in a variable and use it in the same @if block
- Angular: ng-content doesn't render with *ngIf then else
- How to get the next Bi-weekly date based on a given start date and today's date in Google Sheets
- What is the best way to refactor an if else branch
- Unreachable code in if-else structure
- Python if/else/elif
- Ternary conditional operator in Scala