Thank you and I appreciate all assistance!
Prior to updating to WIN10 and O365 I was able to have the following condition work
{=IFERROR(INDEX(Incident!P:P,SMALL(IF((Incident!$Q$2:$Q$301="Yes"),ROW(Incident!$P$2:$P$301)),ROWS(Incident!$p$1
1))),"")}
What this did was go to my Incident sheet and in column P look for the trigger "Yes" and if present return the value in a given cell. Everything is working with the exception of one cell that returning a "0" (ZERO) I have removed the IFERROR and I get the #NUM ! error.
{=IFERROR(INDEX(Incident!G:G,SMALL(IF((Incident!$Q$2:$Q$300="Yes"),ROW(Incident!$G$2:$G$300)),ROWS(Incident!$G$2:G3))),"")}
I have the same formula in multiple cells and they're reporting correctly. If you need data extracts let me know
Prior to updating to WIN10 and O365 I was able to have the following condition work
{=IFERROR(INDEX(Incident!P:P,SMALL(IF((Incident!$Q$2:$Q$301="Yes"),ROW(Incident!$P$2:$P$301)),ROWS(Incident!$p$1

What this did was go to my Incident sheet and in column P look for the trigger "Yes" and if present return the value in a given cell. Everything is working with the exception of one cell that returning a "0" (ZERO) I have removed the IFERROR and I get the #NUM ! error.
{=IFERROR(INDEX(Incident!G:G,SMALL(IF((Incident!$Q$2:$Q$300="Yes"),ROW(Incident!$G$2:$G$300)),ROWS(Incident!$G$2:G3))),"")}
I have the same formula in multiple cells and they're reporting correctly. If you need data extracts let me know