---
title: "Data Validation – check for blank cells"
author: "Phil Bainbridge"
date: 2020-01-27T09:05:00+00:00
modified: 2020-01-27T09:05:09+00:00
canonical_url: https://pulse.appsscript.info/p/2020/01/data-validation-check-for-blank-cells/
markdown_url: https://pulse.appsscript.info/p/2020/01/data-validation-check-for-blank-cells.md
categories:
  - "Sheets"
  - "Snippet"
  - "Solutions"
tags:
  - "pbainbridge.co.uk"
description: "The following Google Apps Script code was developed as a tool to check that all the necessary data existed in a spreadsheet before another function was triggered. The reason for this was that if any..."
---

# Data Validation – check for blank cells

> The following Google Apps Script code was developed as a tool to check that all the necessary data existed in a spreadsheet before another function was triggered. The reason for this was that if any data was missing it would affect the student Group files I was creating (eg no email address or name) that would eventually prevent further functions from running at a later date.

Source: *[The Gift of Script: Data Validation – check for blank cells*](https://www.pbainbridge.co.uk/2019/01/data-validation-check-for-blank-cells.html)

---

*Published by [Phil Bainbridge](https://pulse.appsscript.info/p/author/phillipbainbridge/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/01/data-validation-check-for-blank-cells/](https://pulse.appsscript.info/p/2020/01/data-validation-check-for-blank-cells/)*