20000 rows notification

Itai
Itai ✭✭✭✭✭✭

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

Itai Perez

Project Manager | Transformation Department

Gong cha

If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

https://www.linkedin.com/in/itai-perez-740543116/

Best Answer

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    Answer ✓

    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

Answers

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭
    Answer ✓

    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