> 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/checks/why-doesnt-my-check-match-the-value-i-see-in-google-sheets.md).

# Why doesn't my check match the value I see in Google Sheets?

Check Sheet evaluates the raw value from your spreadsheet, not the formatted value displayed in Google Sheets.

Formatting can change how a value looks without changing the value itself. This means the value you see in the sheet may not be the exact value Check Sheet is checking.

For example:

* A cell formatted as currency may display as `$10.00`, but the raw value may be `10`.
* A percentage may display as `50%`, but the raw value may be `0.5`.
* A date may display in one format in the sheet, but still be stored as a date value by Google Sheets.

When configuring your check, use the underlying value rather than the formatted display text.

You can read more in [Values](/concepts/values.md) and [Conditions](/concepts/conditions.md).

## Notifications use the displayed value

This only affects how Check Sheet evaluates whether a cell matches your check.

When Check Sheet sends a notification, it will use the displayed value from Google Sheets. For example, if a matching cell is formatted as currency and displays as `$10.00`, the notification will show `$10.00`.

## Conditional formatting

Conditional formatting changes how a cell looks. It does not usually change the value in the cell.

If a check is not matching as expected, review the actual cell value and the condition configured in Check Sheet rather than relying only on the colour or visual formatting in the sheet.