Google Sheets automatically update new row with formula

1
votes

Spreadsheet 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?

1
google-sheetsarray-formulasautomatic-updates
Hi, would it be possible to share a copy of your spreadsheet so we have some data to work with? – JPV

1 Answers

0
votes

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?