Google Sheets automatically update new row with formula

Question

I have a sheet I am constantly adding new items on. The current formula in column E, takes the latest price I am paying for the item.

I want to have this formula already built into any new rows added. Here is how it currently looks: Spreadsheet

I have not done any script before, but it looks like this is possible using an array formula.

Where am I going wrong?

Answer 1

Clear out all contents of column E. Then enter in E2

={"Current"; ArrayFormula(iferror(regexextract(trim(transpose(query(transpose(F3:BQ),,rows(A3:A)))),"[^\s]+$")+0))}

and see if that works?