=IF(ROWS(B$10:B10)>$C$2,"",INDEX(Task2.0!A$2:A$3500,SMALL(IF(Task2.0!$A$2:$A$3500=$B$2,IF(Task2.0!$H$2:$H$3500<=$E$2,IF(Task2.0!$H$2:$H$3500>=$D$2,ROW(Task2.0!$H$2:$H$3500)-ROW(Task2.0!$H$2)+1)),ROWS(B$10:B10))))
Can someone tell me what I am missing in the array formula above? I am receiving an error saying that I have too few arguments. I am trying to show the tasks based on the project ID and a date range.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ID
[/TD]
[TD]Count ifs
[/TD]
[TD]Date 1
[/TD]
[TD]Date 2
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1
[/TD]
[TD]Formula
[/TD]
[TD]8/21/18
[/TD]
[TD]9/30/18
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]Array formula
[/TD]
[TD]Array formula
[/TD]
[TD]Array formula
[/TD]
[TD]Array formula
[/TD]
[/TR]
</tbody>[/TABLE]
Sheet - Task2.0
Column A = ID
Column H = Date
Can someone tell me what I am missing in the array formula above? I am receiving an error saying that I have too few arguments. I am trying to show the tasks based on the project ID and a date range.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]ID
[/TD]
[TD]Count ifs
[/TD]
[TD]Date 1
[/TD]
[TD]Date 2
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1
[/TD]
[TD]Formula
[/TD]
[TD]8/21/18
[/TD]
[TD]9/30/18
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]Array formula
[/TD]
[TD]Array formula
[/TD]
[TD]Array formula
[/TD]
[TD]Array formula
[/TD]
[/TR]
</tbody>[/TABLE]
Sheet - Task2.0
Column A = ID
Column H = Date