Profile cover photo
Profile photo
L. LaRae Redford
519 followers -
Love hard, Live well.
Love hard, Live well.

519 followers
About
L. LaRae's posts

Post has attachment
Hello!

I'm creating an assignment sheet for my company and would like for any assignment marked "Done" to be moved to an archive tab in the same sheet.

Here's a link to the spreadsheet.

I've looked through these forums and added a script based on the best answer in this thread. Unfortunately, it's not working. :/

Would love any help ya'll are willing to give.

Thank you!

Here's the script I'm using:

function onEdit() {
// moves a row from a sheet to another when a magic value is entered in a column
// adjust the following variables to fit your needs
// see https://productforums.google.com/d/topic/docs/ehoCZjFPBao/discussion

var sheetNameToWatch = "Assignments";

var columnNumberToWatch = 3; // column A = 1, B = 2, etc.
var valueToWatch = "Done";
var sheetNameToMoveTheRowTo = "Archive";

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getActiveCell();


if (sheet.getName() == sheetNameToWatch && range.getColumn() == columnNumberToWatch && range.getValue() == valueToWatch) {

var targetSheet = ss.getSheetByName(sheetNameToMoveTheRowTo);
var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).moveTo(targetRange);
sheet.deleteRow(range.getRow());
}
}

Post has attachment
Squink Game's "Gummies Playground" got mentioned in the Guardian's "50 Best Android Apps for kids" for 2013!

Post has attachment
Squink Games educational adventure for preschoolers - Gummies Playground - went live today on iTunes, Google Play, and Amazon! Check it out!

Post has attachment
ESRB offers FREE Short-Form ratings for indie developers.

Post has shared content
An interesting viewpoint.
Neil deGrasse Tyson  @neiltyson
One of the great forces of delusion is under-informed pride of country -- Kudos to @HBO& the #Newsroom
https://twitter.com/neiltyson/status/229827628033507328

Post has shared content
Some people consider Friday the 13th unlucky, but we're happy to announce we were lucky enough to be featured on the Google Play store! Come check us out here under Staff Picks at https://play.google.com/store/apps?hl=en and we hope you have a lucky Friday the 13th as well!

Thanks to all of our supporters for helping to get us here!
Photo

#TysonThursday   "The fact that you take a circle of any size. A circle the size of the universe itself and divide it by it's own radius and you get [pi]. That's beautiful. I have to pause and I get misty thinking of this. Another one! That the atoms and molecules in your body are traceable to crucibles in the centers of stars that manufactured these elements over it's lifespan. Went unstable on death. Exploding its enriched guts across the galaxy. Scattering it into gas clouds that would ultimately collapse and make a star and have the right ingredients to make planets and people. Which means we are part of this universe. As I've said many times, and this goes back... not only are we in the universe the universe is in us. That is a profound concept. And I think it's the greatest gift that astrophysics gave culture in the 20th century... but we knew that we are star stuff. We knew that we are star dust at the middle of the 20th century. That connects us to the universe like no other fact. That's beautiful." ~ Neil deGrasse Tyson

Post has shared content
So very cool.
#tysonthursday  
From http://www.livinginiowa.net/

"5. Neil deGrasse Tyson on interdependence: 
"We are all connected. To each other, biologically. To the earth, chemically. To the rest of the universe, atomically." -Neil deGrasse Tyson

6. This photo with the above Tyson quote in mind: " 
Photo

Post has shared content

Post has shared content
"Now where could that fishy be..." now also on the Amazon App Store (for Kindle Fire and Android devices) Buy it before the world ends!
Wait while more posts are being loaded