20000 rows notification

Itai Perez

I have a sheet that is fed from a form, will I get any notifications when the sheet is full or about to get full?

If not, what is the best way to set up an automation or notification for that?

Thank you

Debbie Sawyer

Great Question!

You could set up a prompt to notify you of the number of completed cells in your sheet.

Lets take this screen shot as an example

The First column is called Primary column and the last column is called Actual Date

If you add a column called Cell Count and pop in the formula:

=COUNTIF([Primary Column]:[Actual Date], NOT(ISBLANK(@cell)))

it returns the number 26 in this instance.

Then you can create a workflow that looks at changes in the Cell Count column (where only row1 will ever be changed) and when the cell count gets to 15000 (or what ever limit you like) send an alert to the sheet owner saying, time to think about archiving old records!

Something along those lines... The formula should have the name of your first column then a : then the name of your last column with no row references, then it looks at the whole columns values rather than rows of data.

Does this help at all?

Kind regards

Debbie

Debbie Sawyer

Great Question!

You could set up a prompt to notify you of the number of completed cells in your sheet.

Lets take this screen shot as an example

The First column is called Primary column and the last column is called Actual Date

If you add a column called Cell Count and pop in the formula:

=COUNTIF([Primary Column]:[Actual Date], NOT(ISBLANK(@cell)))

it returns the number 26 in this instance.

Then you can create a workflow that looks at changes in the Cell Count column (where only row1 will ever be changed) and when the cell count gets to 15000 (or what ever limit you like) send an alert to the sheet owner saying, time to think about archiving old records!

Something along those lines... The formula should have the name of your first column then a : then the name of your last column with no row references, then it looks at the whole columns values rather than rows of data.

Does this help at all?

Kind regards

Debbie