Google Sheets: Issue with Formula in Table referencing value in same row by column name

I share here an issue I have faced with Google Sheets when using a formula in a Table that references a column by name.

Goodreads to Notion

This post is a WIP/ WOL. Please comment if you are interested for me to share quickly a final solution/ want to motivate me getting this done.

I have the idea to use Notion for tracking my reading and especially take reading notes.

I use mainly Goodreads to manage the books I have or plan to read/buy and also its community feature to share with other reading friends.

Now I would like a seamless handling between both tools i.e. avoid manually entering of books in Notion and automatic synchronization from Goodreads to Notion.

Moreover, I would like also to track my expenses related to books.

Google Sheets Tricks: Copy formula to whole column

I have learned this tricks in Google Sheets:

Drag and drop all the way down of a column can be a bit cumbersome.

To select all the cells below another one, you can use the hotkey Ctrl+Shift+Arrow Down.

Then you can for example copy/ paste on this whole selection.

To copy a formula in the whole row, you can edit the first cell and use an ArrayFormula

Example : 

=ARRAYFORMULA(IF(ISBLANK(E2:E);"";YEAR(E2:E)))

When you do so the cells must be empty else you will get an error that the formula would overwrite the existing value.