> For the complete documentation index, see [llms.txt](https://documentation.checksheet.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://documentation.checksheet.app/faq/spreadsheet-changes/why-did-check-sheet-send-notifications-after-sorting-my-sheet.md).

# Why were notifications sent after I sorted my sheet?

Check Sheet remembers which cells have already matched your check so it does not keep sending notifications about the same result.

It does this based on the position of the matching cell in your spreadsheet.

If you sort your sheet directly, insert rows in the middle of your data, delete rows, or move rows around, the position of your existing values can change. When that happens, Check Sheet may see some of those values in new cell positions and send notifications again.

For example, if a value in `A10` has already matched your check, Check Sheet remembers that match. If you sort the sheet and the same value moves to `A25`, Check Sheet would now treat `A25` as a new match.

## How to avoid this

If you need to sort or filter your data, use a Google Sheets filter view instead of directly sorting the sheet.

Filter views let you sort and filter what you see without changing the underlying position of the rows in the sheet. This means Check Sheet can continue recognising the cells it has already notified you about.

To create a filter view in Google Sheets:

1. Open your spreadsheet.
2. Select the range you want to sort or filter.
3. Click `Data`.
4. Click `Create filter view`.

You can then sort or filter the data inside the filter view without physically moving the rows for everyone.

## Adding new rows

If your workflow regularly adds new records, add them at the bottom of your sheet where possible.

Avoid inserting new rows in the middle of data that Check Sheet is already monitoring, because this can shift the positions of existing matches and cause duplicate notifications.

If you want the newest or oldest records to appear first, add new rows at the bottom and then use a filter view to display the data in the order you need.

## Deleting rows

Deleting rows can also shift the positions of the rows beneath them.

If you need to keep a record but do not want it to trigger a check any more, consider changing its status or moving it outside the range monitored by your check instead of deleting rows from the middle of the monitored data.

## What to do if you already received duplicate notifications

If duplicate notifications were caused by sorting, inserting rows, deleting rows, or moving rows around, they should stop once the sheet structure stays stable again.

To reduce the chance of it happening again:

* Avoid directly sorting the monitored sheet.
* Add new records at the bottom of the sheet.
* Use filter views for sorting and filtering.
* Avoid inserting or deleting rows in the middle of monitored data.