I have this sample data from my HTML table row.
Tester email@example.com 2018-07-19 1000 1200 new
And I am copying this data to google spreadsheet with a formula of the total of two columns. But when copying the data, the cell with formula will be overridden and removed. Like the sample image below:
Is there a way or function that will automatically create the formula for the two cells?
I tried getting the column letter and row number and combine them so that it will give me the formula. Like
=SUM(column(Letter here)row(): column(Letter here)row() But this doesn't give me the column letter.