Re:Query Google Sheets as virtual tables with SQLite extensi...
by Jakob on Saturday March 18, 2023 @10:11PM
(#35215301)
> set a formula for the entire column
Spreadsheet power users on both excel and sheets do exactly that. It’s called array formula. Press cmd-shift-enter on the cell with the formula and it’s valid for the entire column and can be changed in one central place.
Spreadsheet power users on both excel and sheets do exactly that. It’s called array formula. Press cmd-shift-enter on the cell with the formula and it’s valid for the entire column and can be changed in one central place.