---
title: "Archive Sheet data using tickboxes and Google Apps Script"
author: "Phil Bainbridge"
date: 2022-01-26T20:26:11+00:00
modified: 2022-01-26T20:26:17+00:00
canonical_url: https://pulse.appsscript.info/p/2022/01/archive-sheet-data-using-tickboxes-and-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2022/01/archive-sheet-data-using-tickboxes-and-google-apps-script.md
categories:
  - "Beginner"
  - "Sheets"
  - "Solutions"
tags:
  - "pbainbridge.co.uk"
featured_image: https://pulse.appsscript.info/files/2022/01/Archive-Sheet-data.png
description: "The following Google Apps Script is designed to move a row of data from one Google Sheet tab to another when a tickbox has been selected in a given column. The tool was developed to help colleagues with automatically archiving data that had been actioned. The tool uses an 'onEdit(e) simple trigger' to constantly monitor the Google Sheet for any changes in values. Is it specifically targeted at a tickbox-column only so that it does not archive rows of data on every edit of the Google Sheet."
---

# Archive Sheet data using tickboxes and Google Apps Script

![Archive Sheet data using tickboxes and Google Apps Script](https://pulse.appsscript.info/files/2022/01/Archive-Sheet-data.png)

> Automatically move a row of data from one Google Sheet tab to another when a tickbox is selected.
> [https://www.pbainbridge.co.uk/2022/01/archive-sheet-data-using-tickboxes.html](https://www.pbainbridge.co.uk/2022/01/archive-sheet-data-using-tickboxes.html)Archive a row of data by ticking a box

The following Google Apps Script is designed to move a row of data from one Google Sheet tab to another when a tickbox has been selected in a given column. The tool was developed to help colleagues with automatically archiving data that had been actioned.

The tool uses an ‘onEdit(e) simple trigger’ to constantly monitor the Google Sheet for any changes in values. Is it specifically targeted at a tickbox-column only so that it does not archive rows of data on every edit of the Google Sheet.

Source: *[The Gift of Script: Archive Sheet data using tickboxes*](https://www.pbainbridge.co.uk/2022/01/archive-sheet-data-using-tickboxes.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/2022/01/archive-sheet-data-using-tickboxes-and-google-apps-script/](https://pulse.appsscript.info/p/2022/01/archive-sheet-data-using-tickboxes-and-google-apps-script/)*