The Next Generation: The Animated Series

I want Season 8 of TNG and DS9 done like this!

Posted in Blogmarks | Tagged , , | Comments Off on The Next Generation: The Animated Series

Google Sheets: Add a date when the row was last updated

You have a Google Sheet, you’d like a (or all) row(s) to have a date-stamp added whenever an edit is made. That way others you’re collaborating with will know when the row, or the sheet itself, was last updated at a glance.

If you search for this, you’ll find something like this but it needs some tweaks. This is the third time I’ve searched for it, found it, and then had to re-learn what needed tweaking for it to work for me. So I’m saving it here for my posterity and note-keeping.

Date-stamp whenever a row is modified (🔗)

function onEdit(e) {
    var sh = e.source.getActiveSheet();
    if (sh.getName() !== 'Sheet1' || e.range.getRow() == 1) return; // Skip if we're on another sheet, or not the header row
    sh.getRange(e.range.rowStart, 3).setValue(new Date()) // Put the date in  column 3
}

See it in action

Posted in Programming | Comments Off on Google Sheets: Add a date when the row was last updated

Platform Product Management in 2021 (Product School Talk)

On June 26 I gave webinar for Product School about Platform Product Management. Definitely check it out as there’s a live stream of Q&A and commentary. I’ve turned the talking points into the post below and the slides are posted as well.

Watch the replay of the live event
Continue reading
Posted in Management | Tagged , , | Comments Off on Platform Product Management in 2021 (Product School Talk)

Trader Chris Mai Tai

Mai Tais are better with The Good Ice™

The latest excitement in our house has been the arrival of our countertop ice maker. Why are we excited about an ice maker? 🧊  Because it makes The Good Ice™ – those beautiful nuggets of ice that keep your drink cold, are great for chewing on, and make you feel like your out at a restaurant or tiki bar. I make a pretty decent mai tai, but this ice has taken it from good to great!

Saving my Mai Tai recipe here for posterity and sharing. If you’re not using the High Ball app, it’s a great way to store and share drink recipes.

Posted in Cooking, Tiki | Comments Off on Trader Chris Mai Tai

Things.app Eisenhower-matrix made easy

As you may know, I love Things.app, the Eisenhower matrix, and booking time on my calendar for key tasks.

With the 3.4 release, Things.app gained the ability to craft links directly to tags and items

This made my daily and weekly planning process so much faster, I have a note in Bear that I call up each day and run through the links step-by-step.

My daily planning routine

  1. Review work in progress (things:///search?query=%E2%8F%B3)
  2. Review fires (urgent + important) (things:///search?query=%F0%9F%94%A5)
  3. Review goal items for the week (things://///search?query=%F0%9F%A5%85)
  4. Look at what you’ve selected for tomorrow (things:///show?id=upcoming&filter=tomorrow)
  5. Put time for them on your calendar

My weekly planning routine

  1. Clear all goal items for the week (things:///search?query=%F0%9F%A5%85)
  2. Review work in progress (things:///search?query=%E2%8F%B3)
  3. Review each project, tag items you want to consider for the week with 🥅 (Ctrl-G)
  4. Review goal items for the next week (things:///search?query=%F0%9F%A5%85)
  5. Tag next week’s items:
    1. Important/Urgent: 🔥 (Ctrl-U)
    2. Important: ⚡️ (Ctrl-I)
    3. Not Important / Urgent: ⚾️ (Ctrl-R)
  6. Schedule time on calendar for the big ones

giphy.gif

Posted in Business, Management | 3 Comments