Update, watched some YouTube on this lol, this worked:
=IF(B2="","",FILTER(FILTER(TData,IF(B2="All",1,TData[EMPLOYEE NAME]=B2)*(TData[AUDIT DATE]>=C3)*(TData[AUDIT DATE]<=C4)*IF(E3="All",1,TData[SHIFT]=E3)*IF(E4="All",1,TData[TYPE]=E4)*IF(E2="All",1,TData[REASON]=E2)),{1,1,1,1,0,1,1}))
Bookmarks