Qiita Teams that are logged in
You are not logged in to any team

Log in to Qiita Team
Community
OrganizationAdvent CalendarQiitadon (β)
Service
Qiita JobsQiita ZineQiita Blog
9
Help us understand the problem. What is going on with this article?
@takaku_t

Googleスプレッドシートで、昨日までの日付列を毎朝自動で非表示にするスクリプト

More than 5 years have passed since last update.

業務でGoogleスプレッドシートをガントチャート的に使っていて、もう過ぎた日付の列を毎回手作業で非表示にするのがだるかったのでスクリプト書いた。

hide
function hide() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("hogehoge");
  var column = 4;
  var today = new Date();
  while (column <= ss.getLastColumn()){
    if(sheet.getRange(2, column).getValue() < (today.getTime()-(60*60*24*1000))){
      var range = sheet.getRange(1, column);
      sheet.hideColumn(range);
    }
    column++;
  }
}

トリガーを毎朝5時に仕掛けたので、朝スプレッドシートを開くと昨日までの列は非表示になっている。快適。

9
Help us understand the problem. What is going on with this article?
Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
takaku_t

Comments

No comments
Sign up for free and join this conversation.
Sign Up
If you already have a Qiita account Login
9
Help us understand the problem. What is going on with this article?