Spreadsheet tip: “is not” or “is not equal to”

If you are looking to set up a condition in a spreadsheet function in a situation where you want to include everything but one thing, you need to use the following:

"<>EXCLUDED_TERM"

Turns out the “less-than/greater-than” combo sign means “not equal to”, and it applies to text strings in addition to number strings.

I wasn’t sure what terms to search for initially, and relevant results for “is not”, and “is not equal to” were not giving me the answer I needed.┬áIncluding terms such as “spreadsheet”, “Apple Numbers”, “function” and “formula” didn’t help either.

Continue reading “Spreadsheet tip: “is not” or “is not equal to””

Advanced Tips for Drafts App

Often advanced features in my favorite apps are tough to explain because they are so open to customization. Examples usually help. Here are some handy Drafts tips I’ve either discovered or created that might give you some idea on how to take advantage of Dropbox actions, URL Actions, and email actions.

– Use date stamps to create a scratchpad text dump file

– Log your tweets

– Log your Google searches

– Log everything!

– Use IFTTT and email action to subscribe in Google Reader

– Use date stamps for an auto-created monthly journal text file

– Use bookmarklets to log webpages or send to Reminders Continue reading “Advanced Tips for Drafts App”

Meditation Tips From A Beginner

I’ve been having some discussions with a friend who’s been wanting to get into meditation, and I thought I’d share the following email I sent him. I know in other areas of my life where I am no longer a beginner, I sometimes find it tough to get back into the mindset of one in order to properly help.┬áI’ve been meditating fairly regularly (daily) for about 9 months now. Continue reading “Meditation Tips From A Beginner”

Auto-Increment File Names in OS X with Hazel

For client artwork, I save a lot of versions of files. Enough so that I got tired of manually incrementing the file names when saving JPEGs from Photoshop and decided to see if Hazel could automate this for me. It wasn’t apparent how to do this at first, but the Hazel developer steered me in the right direction. Here’s how to do it.

Continue reading “Auto-Increment File Names in OS X with Hazel”