Hello,

I tried to populate the Assignment cell D12 of Current Week View sheet but this formula isn't working. Does anyone know why not? My objective is to populate the cells C12:L21.

Thank you for any help or suggestions,
Billy

Formula: copy to clipboard

=IFERROR(INDEX(Assignments!$C:$C,SMALL(IF(Assignments[Due Date]=DATE(WkYear,WkMonthNum,C$10),ROW(Assignments[Assignment])),ROWS($1:1))),"")