"You've entered too many arguments for this function" error

Hello,

Could someone please help me re-write this formula to not error please?
I understand it should be done with AND & OR functions, but I don't know enough to rebuild this formula.

Thanks!

=IFERROR(INDEX(Tracking!$A$1:$A$1000,SMALL(IF(Tracking!$D$1:$D$1000="Near Miss",ROW(Tracking!$D$1:$D$1000),IF(Tracking!$D$1:$D$1000="RO - Near Miss",ROW(Tracking!$D$1:$D$1000),IF(Tracking!$D$1:$D$1000="Medical Aid",ROW(Tracking!$D$1:$D$1000),IF(Tracking!$D$1:$D$1000="Lost Time",ROW(Tracking!$D$1:$D$1000),IF(Tracking!$D$1:$D$1000="Medical Aid - GRTW",ROW(Tracking!$D$1:$D$1000)))),ROW()-1)),""))

Try this
(maybe it might be right)

=IFERROR(INDEX(Tracking!$A$1:$A$1000,SMALL(
IF(OR(Tracking!$D$1:$D$1000="Near Miss",
Tracking!$D$1:$D$1000="RO - Near Miss",
Tracking!$D$1:$D$1000="Medical Aid",
Tracking!$D$1:$D$1000="Lost Time",
Tracking!$D$1:$D$1000="Medical Aid - GRTW"),
ROW(Tracking!$D$1:$D$1000), ROW()-1))),"")

The formula is used to automatically copy a row's cell contents from one sheet to another sheet based on certain trigger phrases on the D1:D1000 range.

Example: If "Sheet1!D1" contains "Medical Aid" (or any other of the trigger phrases) then the formula will copy the entire contents of all the cells in that row to a row on Sheet2.

The formula worked perfectly UNTIL we added two more trigger phrases. Previously there were 3 trigger phrases and now there are 5.

Originally Posted by José Augusto

Try this
(maybe it might be right)

=IFERROR(INDEX(Tracking!$A$1:$A$1000,SMALL(
IF(OR(Tracking!$D$1:$D$1000="Near Miss",
Tracking!$D$1:$D$1000="RO - Near Miss",
Tracking!$D$1:$D$1000="Medical Aid",
Tracking!$D$1:$D$1000="Lost Time",
Tracking!$D$1:$D$1000="Medical Aid - GRTW"),
ROW(Tracking!$D$1:$D$1000), ROW()-1))),"")

The error for this formula now says "too few arguments"

Originally Posted by ben_hensel

Then can you post an example spreadsheet of where it was working?

Also it looks like this is the INDEX(SMALL) array construction, is that what it's doing?

I will sanitize and submit as soon as I can.

Here is a sanitized version.
Please ignore the REF errors, they occurred after sanitizing.
The formula in question is found in the cells on the OI SHEET
Generally the formula copies from TRACKING SHEET to OI SHEET

It works perfectly! Thank you!