Validations using cell criteria and checkboxes

Marketing Analytics in Google Sheets

Luke Pajer

Digital Marketing Specialist

Data validation for common mistakes

data table - common mistakes

Marketing Analytics in Google Sheets

Data validation for common mistakes

data table - common mistakes - landing page

Marketing Analytics in Google Sheets

Data validation for common mistakes

data table - common mistakes - email address

Marketing Analytics in Google Sheets

Text validation: URL and email validity

URL validity

  • Criteria: 'is valid url'
  • Flagged if URL structure is invalid

URL validity settings

Marketing Analytics in Google Sheets

Text validation: URL and email validity

URL validity

  • Criteria: 'is valid url'
  • Flagged if URL structure is invalid

Email validity

  • Criteria: 'is valid email'
  • Flagged if email address is invalid

email validity settings

Marketing Analytics in Google Sheets

Data validation: checkboxes

Checkbox

  • Adds interactive checkboxes to cells
  • Great for cells with binary values

checkbox validation settings

Marketing Analytics in Google Sheets

Data validation: checkboxes

Checkbox

  • Adds interactive checkboxes to cells
  • Great for cells with binary values
  • Cell value based on checkbox status
  • Custom cell values for checked and unchecked boxes

checkbox in google sheets

Marketing Analytics in Google Sheets

Let's get to work!

Marketing Analytics in Google Sheets

Preparing Video For Download...