Error: Shared Formula master must exist above and or left of clone

I want to insert new rows dynamically into my sheet and have them inherit the formula used above.

  const workbook = await readWorkbook('./sample-sheet.xlsx')
  const worksheet = workbook.getWorksheet('Consumables')
  const row = worksheet.getRow(7)

  const column = 'O'
  const value = row.getCell(column).value
  console.log(`current value of ${column}`)
  console.log(value)
  console.log(row.getCell(column).formulaType)

  row.getCell(column).value = {
    sharedFormula: `${column}6`, result: 0
  }

  row.commit()

  await saveWorkbook(workbook, 'export.xlsx')

It logs this error

Error: Shared Formula master must exist above and or left of clone
 .....
......

This works for some columns. So my question is, how do I set a share formula? or better yet, how can I achieve this differently if there’s an alternative