✅
Check Sheet
HomeInstallPricingBlogSupport
  • 👋Introduction
  • ⬇️Installing
  • 🚀Getting Started
  • 💡Concepts
    • Checks
    • Conditions
    • Values
    • Notifications
  • ✏️Workflows
    • Creating a Check
    • Editing a Check
    • Deleting a Check
    • Pausing a Check
  • ℹ️Examples
  • ⚠️Limits
Powered by GitBook
On this page
  • Numbers
  • Text
  • Dates

Was this helpful?

  1. Concepts

Conditions

PreviousChecksNextValues

Last updated 1 year ago

Was this helpful?

You can create checks on your spreadsheet data based on a variety of conditions. The conditions you can use depends upon the type of data that you are checking.

Numbers

For cells containing numbers you can define checks to see if they are:

  • Valid Number

  • Not Valid Number

  • Empty

  • Not Empty

  • Equal To

  • Not Equal To

  • Greater Than

  • Greater Than Or Equal To

  • Less Than

  • Less Than Or Equal To

  • One Of ( list of values to compare against)

  • Not One Of ( list of values to compare against)

  • Matches Regex ( to test the value)

  • Between (inclusive range of values as a , e.g. 1,5 means between 1 and 5)

Text

For cells containing text you can define checks to see if they are:

  • Empty

  • Not Empty

  • Equal To

  • Not Equal To

  • Starts With

  • Ends With

  • Contains

  • Does Not Contain

Dates

For cells containing dates you can define checks to see if they are:

  • Yesterday

  • Today

  • Tomorrow

  • Equal To

  • Not Equal To

  • Before

  • After

One Of ( list of values to compare against)

Not One Of ( list of values to compare against)

Matches Regex ( to test the value)

💡
CSV
CSV
JavaScript RegExp
CSV
CSV
CSV
JavaScript RegExp