The ARRAYFORMULA function in Google Sheets lets you perform the same operation on a range of cells without needing a formula in each cell.
The ARRAYFORMULA function in Google Sheets lets you perform the same operation on a range of cells without needing a formula in each cell.
The Google Sheets 'Viewer' role stops you editing the content, but also means you can't resize rows or expand pivot tables.
Buy me a coffee