---
title: "Clear cell contents on Google Sheet edit"
author: "Phil Bainbridge"
date: 2019-11-26T10:49:40+00:00
modified: 2019-11-25T22:20:06+00:00
canonical_url: https://pulse.appsscript.info/p/2019/11/clear-cell-contents-on-google-sheet-edit/
markdown_url: https://pulse.appsscript.info/p/2019/11/clear-cell-contents-on-google-sheet-edit.md
categories:
  - "Sheets"
  - "Snippet"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2019/11/clear-cell.png
description: "Screenshot of coloured columns to highlight actions This is designed to clear the adjacent cell to the right of the one that has just been edited - so long as it is within the column..."
---

# Clear cell contents on Google Sheet edit

![Clear cell contents on Google Sheet edit](https://pulse.appsscript.info/files/2019/11/clear-cell.png)

![Screenshot of coloured columns to highlight actions](https://pulse.appsscript.info/files/2019/11/clear-cell.png)

 Screenshot of coloured columns to highlight actions

> This is designed to clear the adjacent cell to the right of the one that has just been edited – so long as it is within the column we specify.

It was developed as I was testing the available options for a Stock Inventory system where an item that was to be marked as back in stock would automatically clear an email timestamp in the adjacent cell (ready for the whole ordering process to start again).

Source: *[The Gift of Script: Clear cell content on Google Sheet edit*](https://www.pbainbridge.co.uk/2019/08/clear-cell-content-on-google-sheet-edit.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/2019/11/clear-cell-contents-on-google-sheet-edit/](https://pulse.appsscript.info/p/2019/11/clear-cell-contents-on-google-sheet-edit/)*