Auto-Populating Data From One Sheet To The Other

My structure is 2 separate tabs in the excel sheet. In one sheet, my "Devops Tasks" sheet, I have a status of "COMPLETE", and currently, everything besides 2 are set to "INCOMPLETE".

When I set the status to "COMPLETE" my formula populates this data over here to my other sheet which is labeled as "Handover Report" within my "Completed DevOps Tasks This Shift":

Right now though, it only populates as #NAME? - What exactly am I doing wrong here in this formula?

=@IF(COUNTIF('DevOps Tasks'!C[6],"COMPLETE")>=4,INDEX('DevOps Tasks'!C[2],@AGGREGATE(15,6,@ROW('DevOps Tasks'!C[6])/(@'DevOps Tasks'!C[6]="COMPLETE"),4)),"")

As a side note, but maybe not entirely relevant - one way I'm auto-populating is through what I do within JS:

    const completedTasksTable = handoverSheet.addTable({
        name: 'CompletedTasks',
        ref: 'A' + (handoverSheet.rowCount + 1),
        columns: [
            { name: 'ID', filterButton: true, width: 15 },
            { name: 'Title', filterButton: false, width: 50 },
            { name: 'Completed By', filterButton: true, width: 25 },
            { name: 'Sprint', filterButton: true, width: 20 }
        ],
        rows: Array(10).fill().map((_, index) => [
            { formula: `=IF(COUNTIF('DevOps Tasks'!H:H,"COMPLETE")>=${index + 1},INDEX('DevOps Tasks'!C:C,AGGREGATE(15,6,ROW('DevOps Tasks'!H:H)/('DevOps Tasks'!H:H="COMPLETE"),${index + 1})),"")` },
            { formula: `=IF(COUNTIF('DevOps Tasks'!H:H,"COMPLETE")>=${index + 1},INDEX('DevOps Tasks'!D:D,AGGREGATE(15,6,ROW('DevOps Tasks'!H:H)/('DevOps Tasks'!H:H="COMPLETE"),${index + 1})),"")` },
            { formula: `=IF(COUNTIF('DevOps Tasks'!H:H,"COMPLETE")>=${index + 1},INDEX('DevOps Tasks'!B:B,AGGREGATE(15,6,ROW('DevOps Tasks'!H:H)/('DevOps Tasks'!H:H="COMPLETE"),${index + 1})),"")` },
            { formula: `=IF(COUNTIF('DevOps Tasks'!H:H,"COMPLETE")>=${index + 1},INDEX('DevOps Tasks'!A:A,AGGREGATE(15,6,ROW('DevOps Tasks'!H:H)/('DevOps Tasks'!H:H="COMPLETE"),${index + 1})),"")` }
        ])
    });


    const completedTasksHeaderRow = handoverSheet.getRow(completedTasksTable.headerRow?.firstRow || +1);
    if (completedTasksHeaderRow) {
        completedTasksHeaderRow.font = { bold: true };
        completedTasksHeaderRow.fill = {
            type: 'pattern',
            pattern: 'solid',
            fgColor: { argb: 'FFF0F5FF' }
        };
    }
    
    completedTasksRow.fill = {
        type: 'pattern',
        pattern: 'solid',
        fgColor: { argb: 'FF1E4D8C' }
    };
    completedTasksRow.font = { color: { argb: 'FFFFFFFF' }, bold: true };