Profile

Cover photo
L. LaRae Redford
Worked at Playdom
528 followers|248,329 views
AboutPostsPhotosVideos+1'sReviews

Stream

L. LaRae Redford

Problem/Coding Help  - 
 
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());
}
}
Google Groups allows you to create and participate in online forums and email-based groups with a rich experience for community conversations.
1
L. LaRae Redford's profile photo
 
I apologize. When I c/p my message here, the link to the document broke.

Here is the link to the document I'm needing help on: https://docs.google.com/spreadsheets/d/1JtU0vY7wbUkrTyhmAemp1HZR5L9qCfPpDzVcogdf0_s/edit#gid=0
Add a comment...

L. LaRae Redford

Shared publicly  - 
 
Squink Game's "Gummies Playground" got mentioned in the Guardian's "50 Best Android Apps for kids" for 2013!
From Disney to Toca Boca, maths to Despicable Me, The Dandy to Minecraft videos: this year's pick of the best children's apps on Google Play
1
Add a comment...

L. LaRae Redford

Shared publicly  - 
 
ESRB offers FREE Short-Form ratings for indie developers.
1
Add a comment...

L. LaRae Redford

Shared publicly  - 
 
 
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!
1
Add a comment...

L. LaRae Redford

Shared publicly  - 
 
 
Star Trek ToS fans may find this relevant.
1
Add a comment...

L. LaRae Redford

Shared publicly  - 
 
 
"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!
1
Add a comment...

L. LaRae Redford

Shared publicly  - 
 
 
Oh Stinky, is there anything you won't eat?  Well I guess all the bad guys, technically...
1
Add a comment...
In her circles
457 people
Have her in circles
528 people
Matthew Stopard's profile photo
Stephanie Bayer's profile photo
Parham Moradyab's profile photo
Alex McGilvray's profile photo
Leslie D's profile photo
Adam Creighton's profile photo
NOM Productions's profile photo
Omar Husban's profile photo
Jason Koenig's profile photo

L. LaRae Redford

Shared publicly  - 
 
Squink Games educational adventure for preschoolers - Gummies Playground - went live today on iTunes, Google Play, and Amazon! Check it out!
2
Add a comment...

L. LaRae Redford

Shared publicly  - 
 
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
1
Add a comment...

L. LaRae Redford

Shared publicly  - 
 
#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
7
Add a comment...

L. LaRae Redford

Shared publicly  - 
 
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: " 
1
Add a comment...

L. LaRae Redford

Shared publicly  - 
 
Congrats to NOM Productions for releasing Down the Hatch! on Amazon!
2
Add a comment...
People
In her circles
457 people
Have her in circles
528 people
Matthew Stopard's profile photo
Stephanie Bayer's profile photo
Parham Moradyab's profile photo
Alex McGilvray's profile photo
Leslie D's profile photo
Adam Creighton's profile photo
NOM Productions's profile photo
Omar Husban's profile photo
Jason Koenig's profile photo
Basic Information
Gender
Female
Story
Tagline
Love hard, Live well.
Introduction
I'm a divorced mother of 2 who has lived all over the states and spent time in Japan as the daughter of a career Navy man. I currently work in the game industry and LOVE it. I'm very lucky to have a wonderful man in my life and very good friends.
Bragging rights
I have worked for both LEGO and Disney. Both of my kids are gamers. Published Writer.
Work
Occupation
Program Manager, Associate Producer, ScrumMaster
Employment
  • Playdom
    Progam Manager, 7 - 2013
L. LaRae Redford's +1's are the things they like, agree with, or want to recommend.
Rocket Rangers Preschool
market.android.com

Rocket Rangers Preschool is a fun collection of simple educational games for children ages 2 to 5.This fun, space-themed game consists of se

Rocket Rangers Preschool FREE
market.android.com

Rocket Rangers Preschool is a fun collection of educational games for children ages 2 to 5. This is a FREE trial version with 5 of the 10 re

Gummies Playground
market.android.com

Just in time for Back to School! Gummies Playground - the only educational adventure that grows along with your child!A teacher-approved, pr

Glassdoor – an inside look at jobs & companies
www.glassdoor.com

Search jobs then look inside. Company salaries, reviews, interview questions, and more - all posted anonymously by employees and job seekers

Glass Bottom Games
www.glassbottomgames.com

In defense of non-regenerating health. Another blogger on Gamasutra (Josh Bycer, here) recently made a post focusing on the merits of regene

Avril Lavigne - Nobody's Home (With Lyrics)
www.youtube.com

NOBODY'S HOME ---►► http://UniqueTones.info/avril ◄◄--- A Video I Made With The Lyrics To Nobody's Home - By Avril Lavigne. Software Used: W

WANT: The Starks of Winterfell Crocheted Doll Set [Pic]
www.geeksaresexy.net

A big Game of Thrones set including Lord Eddard, Lady Catelyn, their five children and Eddard's son Jon Snow, as well as two grey and one

Tiny Tower devs are happy to inspire Zynga’s new game, Dream Heights (im...
venturebeat.com

Zynga is synonomous with ripping off other developers' games, but very rarely do they get called out for it. In fact, they've ironically tri

Gangnam Style (강남스타일)
market.android.com

Shop Google Play on the web. Purchase and enjoy instantly on your Android phone or tablet without the hassle of syncing.

Down The Hatch!
market.android.com

Join Stinky as he falls from grace in a sinful shower of decadent desserts. Meet Stinky, a young little imp who’s always getting into troubl

The Story of Stinky
www.youtube.com

How Stinky got started on his gluttonous journey. Down the Hatch is an exciting new accelerometer-based game out now for iOS and Android!

CrazyThyroidLady ™: THYROID DISEASE FEELS LIKE...
crazythyroidlady.blogspot.com

THYROID DISEASE FEELS LIKE... When asked, “Hey Crazy Thyroid Lady, what does it feel like to have a thyroid disease?” I usually just give a

Jo is fantastic! Always does a great job.
Public - a year ago
reviewed a year ago
1 review
Map
Map
Map