Copy Rows Between Sheets Based on Checkbox

I am trying to create a calendar or events based off a master list of events on another sheet.

The source sheet is a master list of all possible events. That sheet contains a column of check boxes. When a checkbox is checked I would like it to automatically copy that row from the source sheet to the destination sheet. The end result is a source sheet that only contains events we have decided to track.

Is that possible and if so what is the formual?

Please type real slow as I am a newbie. Thanks in advance.

Find more posts tagged with

Calendar View

Conditional Formatting

Project Management

Cell linking

Comments

Shaine Greenwood

Hello Scot,

We currently don't have a way to conditionally copy or move a row from one sheet to another, such as when a checkbox is checked. Our Product team is working on this type of feature and I'll get your vote down for this on our enhancement request list for further consideration.

If you're looking for this type of functionality, you may want to check out a third party integration service, such as with Zapier or Azuqua, that can automate your process.

Scot Crockett

Great. Thank you Shaine.

kim28026

i vote for this too

John Simon

I vote for this too! We would like to use a feature like this to make it easy (by just checking a box) to move or copy rows from the main task list to another sheet that is specifically for items that have entered production.