Post is pinned.
GitHub Community found here:

https://github.com/UMGoogleAppsDevs

Hi everyone! Today is my last day at UM; I'll be leaving Ann Arbor to start a PhD in the fall. I wanted to say thank you for being such a great community for me, and I will definitely be lurking forever more. Please do stay in touch, and thanks again!

Hello!

Does anyone know the function to reference a column in Google Spreadsheet via name and not index? I seem to remember Ridley mentioned that Google made this update at some point...but I can't seem to find it.

Post has attachment
(Cross-posted at a couple other communities)

Hi guys! I wanted to let you know about a great BSA position (mine!) opening at UMSI. I'll be leaving later this summer to go to grad school, but in the meantime the idea is for me to have some overlap with my replacement. If you want to work at an interesting, dynamic, tech-savvy college with fun, smart people, and get a chance to learn all the time while contributing to lots of different projects, I encourage you to check it out: http://careers.umich.edu/job_detail/141920/business_systems_analyst_intermediateassociate

Hi everyone, hope you're excited for next week's meeting! PLEASE RSVP by Tuesday if you haven't yet, so I can get us a nice big table at HopCat. I'll also send out a reminder to the invitees who haven't responded.

If you want to join this discussion of the Google Cloud Platform but can't find the invite, let me know and I'll send it your way post haste.

Have a lovely weekend--Happy Easter to those who celebrate :)

Hi all! Meeting invite has been posted. We'll be gathering at 2 p.m. on April 21, probably at HopCat. Let me know if you didn't get the invite.

Hi all,

It's been a long time since we've met, and Rob and I think it might be a good idea to get together again.

We are proposing a casual, socially oriented meeting (probably at HopCat) where Rob will lead a conversation on the suite of excellent tools in the Google Cloud Platform (https://cloud.google.com/). We may also ask our friends in some of the other relevant CoPs to join in on the fun.

Please, even if there's zero chance you'll attend, fill out this very short interest form by February 24: https://goo.gl/forms/3tXVzh3ZlPE8Kh4H2

This helps us get an accurate count and gives us a sense of the general level of interest in the group.

This was originally sent to the MCommunity list. There will be a reminder.

Thank you kindly. Rob and I are really excited to see you all again!

(Cross-posted to the MCommunity list.)

There'll be an event this Friday at Ross that may be of interest to you. Here are the details:

Learning about Google's UX Design Approach
Friday, February 3rd (1:00pm - 3:00pm)
RossB2585
The event is open to the public
Join us this Friday when we'll be learning more about Google's UX Design Approach from a former Rosser and member of the Google team. The webinar will be followed by a rapid prototyping session of a google app with your D+B Facilitation team. 

Here's a little Apps Script tidbit for you, specific to Sheets.

Sometimes you want to make note of when there was a change in a sheet. Apps Script has event objects (onEdit and onChange) and a built-in function in the DriveApp (get last updated) that can assist with that. However, they are limited. If the change you're looking for happens in a cell whose value comes from a formula (in my case, IMPORTRANGE from another sheet), the built-in "get last updated" functions and onEdit/onChange event objects actually don't cut it--that type of value change doesn't register in the sheet.

But you can hack it yourself, rather simply. Let's say the cell whose value you want to note changes of is in B10. The trick is to compare it on a regular basis (using triggers) to a different cell, say D10. Then, if the values are different (meaning B10 has changed, the thing you want to know), first update D10 to have the current value of B10; and input the current datetime into another cell, say E10. Run this trigger as often as you like. Whatever's in E10 can be used to note, with reasonably good accuracy, when the cell's value was last changed. Here's how it worked for me:

function myFunction() {
var agg = SpreadsheetApp.getActiveSheet().getRange('B10');
var aggval = agg.getValue();
var comp = SpreadsheetApp.getActiveSheet().getRange('D10');
var compval = comp.getValue();
if (aggval != compval) {
var newcomp = comp.setValue(aggval);
var date = new Date();
var dateval = SpreadsheetApp.getActiveSheet().getRange('E10').setValue(date);
}
}

Now in the script editor, I simply go to Resources>Current project's triggers and set it up to run myFunction every four hours.

Hi everyone.

Rob and I have talked and, following several meetings with low attendance, we've decided to make this community online-only for now.

We may have special events around specific topics, but there will no longer be regular in-person meetings until we can figure out a way to make the content useful enough to spur consistent good attendance. If you have ideas about how to do this, please let us know.

Thanks.
Wait while more posts are being loaded