this action would increase the number of cells in the workbook above the limit of 2000000 cells.

Question

Problem :

I am getting below google sheet error

this action would increase the number of cells in the workbook above the limit of 2000000 cells.

Answer 1

According to the Files you can store in Google Drive Google Sheets has the 5 million cells limit by spreadsheet. 

I myself tested the above scenario by trying to insert a 1,999,999 columns to the spreadsheet that contains a single sheet with a single cell (A1) by using the below script:

function testCol() {
  SpreadsheetApp.getActiveSheet().insertColumns(1, 1999999)
}