Tag Info

New answers tagged


Have you tried isBlank() function?


The problem with your code is that your using the function getBackgroundColor() which doesn't exist. Use getBackground() instead. And make sure you're passing both range and color code as strings (enclosed with "). Also make sure to pass color codes in lower case ("#ffffff", not "#FFFFFF").


This script checks if column B is updated, then updates the last column in that row with a timestamp: function onEdit(event) { var sheet = event.source.getActiveSheet(); // note: actRng = the cell being updated var actRng = event.source.getActiveRange(); var index = actRng.getRowIndex(); var cindex = actRng.getColumnIndex(); if (cindex == 2) ...


Note: Apparently the Domain Service "...was deprecated on May 15, 2014, and will be turned off on November 20, 2014. To manage your domain, use the Admin SDK Directory and Admin SDK Reports advanced services instead. See the guide to migrating from Domain service." per the documentation page for the UserManager Class.

Top 50 recent answers are included