Sign up
  • Home
  • Productivity

Reach any goal this year with a spreadsheet, a calendar, and the SMART system

Productivity tips

15 min read

Reach any goal this year with a spreadsheet, a calendar, and the SMART system

By Emily Irish · March 30, 2021
smart-goals primary img

It always starts the same way. It's January, or a new academic year, or a new fiscal quarter, and you have more goals than—well, I'd put a sports reference here, but I don't really watch sports. You get the picture: you have a long list of goals to achieve in the coming months, and you'll be goshdarned if you don't achieve them all.

But then, a week later, your motivation starts to fizzle. And six months down the road, you're no closer to achieving your goals than you were when you set them.

You're not alone in your shame. Over half of New Year's resolution-makers failed to stick to their plans after six months. So how do you break the mold?

Achieving big goals isn't easy, which is why most people don't accomplish most of theirs. But with the proper framework, you can do just about anything. Unfortunately, you can't just write a to-do list and hope for the best. You'll have to make a plan—a HARD and SMART plan that will make your goals more achievable. And, with the help of automation, you're going to overcome any impediments that might stop you in the process.

Here's how to go from goal-setting to celebrating your goal accomplishment. All you need is your favorite to-do app, a spreadsheet, and a calendar.

SMART vs. HARD goals

HARD goals

The first step, of course, is setting a goal, but that's not as easy as it sounds if you want to, you know, achieve the goal. It's actually HARD. [Ed note: Pun intended.]

The problem with setting great goals is double-edged: On the one hand, you need a goal that will motivate and inspire you. But on the other hand, you need goals you can actually accomplish.

The solution? Set goals that are HARD and then create a SMART roadmap or plan of action. But those are acronyms, so let's look at what they mean.

Coined in the mid-20th century, the SMART goal criteria have been widely accepted as the "goal"-d standard of goal setting. [Ed note: Pun intended. Again.] This method requires goals to be Specific, Measurable, Achievable, Realistic, and Time-Bound.

In 2020, researchers at Leadership IQ repeated a 2010 survey to see whether someone's goals (career or personal) would actually help them achieve great things. Ultimately, they found that simply setting SMART goals didn't necessarily mean you'd have a greater chance of achieving those goals: only 30% of the 12,000 people surveyed said they felt a "strong sense of urgency to achieve their goals."

But we don't have to give up on goal-related acronyms altogether! Researchers also found that successful goal-setters set a different type of goal, which they termed HARD goals. The HARD mnemonic stands for:

  • Heartfelt or enriching your own life and the lives of others. Who else is impacted positively by the achievement of this goal?

  • Animated and vivid in your imagination. What does my business, career, or life look like when I achieve this goal? (Visualize it!)

  • Required for personal or professional well-being. Why is this goal so necessary? What are the stakes (personal or professional)?

  • Difficult in that they force you to leave your comfort zone and learn new skills. What will I have to learn to accomplish this? Where will I have to stretch myself? (Record this answer in great detail.)

Overall, participants who set HARD goals were more likely to feel urgency around their goals, visualize their progress, and—get this—love their jobs than those who set SMART goals.

It might seem like the SMART system directly conflicts with the HARD system, but they can actually complement each other well. You just need to be intentional.

When you're setting your business and personal goals, tap into the power of intrinsic motivation by detailing the HARD criteria of your goal: How will it make your or someone else's life better? What does your world look like after you achieve it? How will you grow while pursuing this goal?

Use these questions to vet every goal you have to make sure they're ones you can actually achieve and are worthwhile. You'll probably find that using the HARD criteria to refine your goals helps you mentally reframe what's worth pursuing. Because the SMART system emphasizes achievability, you can easily fall into the trap of setting goals that don't require or inspire growth, personally or professionally. Don't just set goals you know you'll easily reach with the skills and knowledge you have now; set ones that ask you to learn.

Once you have this big-picture vision of your goal, it's time to get SMART. As effective as HARD goals are at spurring you into immediate action, you might find yourself losing motivation after a while. That's why you should create an actionable, trackable plan to help you consistently work toward your goal.

There's no need to get fancy here; you don't need to buy a new planner or invest in another app subscription. Let's look at how you can create a SMART plan using just a spreadsheet and a regular calendar—as well as how to overcome internal excuses.

Build a SMART plan

SMART goals

To keep yourself from becoming overwhelmed with your goal, you're going to make a spreadsheet roadmap that includes all the tasks that lie between you and your goal.

You'll want to create at least four columns in this spreadsheet:

  1. Task

  2. Description

  3. Ideal start date

  4. Ideal deadline

It may also be helpful to add criteria like "Stage" or "Phase."

When trying to decide what counts as a "task," keep the SMART criteria in mind. The goal of this criteria is to minimize the amount of friction between you and achieving your goal.

Specific. Give yourself several small, specific mini-goals to accomplish that are all part of the larger goal. This provides the clarity and focus you need to get everything done.

Measurable. Each task should have some form of measurement attached to it—give each task clear success criteria. This relieves indecision and streamlines movement from one task to the next.

Achievable. Each task should be something you know you can do with hard work and self-education. This provides the confidence and clarity you need to reach the larger goal. When setting tasks, take the time to understand your strengths and limitations (time, skill, and resources) and how they'll affect each task, so you can keep tasks achievable.

Realistic. Stepping outside your comfort zone is crucial to growth, so don't let this criterion hold you back from dreaming big with your HARD goals. But your SMART plan isn't designed for big dreams; it's designed for mapping out the road between you and achieving that big dream. Keep tasks realistic (for example, "write 500 words every day" versus "write a blog post every day") even though they may be difficult.

Time-bound. If you have month-long deadlines for a task that will take you three hours, you're much more likely to procrastinate and delay your overall progress. Don't sign up for more than you can handle, but make sure there's enough of a time gap to keep you focused.

Make decisions now

When it comes to your SMART plan, there are really only two options: the easy way and the right way. The easy way looks like this:

Planning in Excel

At first glance, this may seem like a good plan. I've assigned tasks into stages and given myself consistent start dates and deadlines. I've even given myself unique tasks for the building blocks of my goal.

The problem is, when January 1 rolls around and I sit down to work on these goals, I'm suddenly bombarded with questions and decisions: Which character should I start with? How do I become an expert on the Industrial Revolution? What resources are out there and how can I find them?

You see the problem. I waste time—and may give up altogether—if I spend my momentum on making small decisions in the moment.

Take the time to make the small decisions now. Focus your brainpower on breaking your goal into individual actions. Trust me: it's easier to do this all at once.

A more detailed plan like the one below gives me more direction and control, so I waste less time figuring out what to do, and instead, just do it:

SMART task planning
Break your goal down into detailed individual actions

Once you've set up your plan with the concrete details, it's time to start using it!

Make your plan part of your life

You can have the best plan in the world, but if you don't translate that plan into daily actions and habits, it won't matter. Starting with a thorough plan gives you a lot of options for integrating into your daily life. Get creative! But first, make sure you at least cover these two things.

1. Get your plan into a project management or to-do list app

A spreadsheet will help you get everything organized, but it won't help you stay on track daily. Your next step is to translate your plan from a spreadsheet into an app where you'll regularly keep tabs on its progress.

For some goals, this app might be a project management tool. For others, a task management or to-do list app is sufficient. It's tough to know which is best for your unique situation, so here are some criteria to consider when picking a home for your goal plan:

  • Does your goal require collaboration or rely on the work of others?

  • Does your SMART plan include many and frequent tasks and subtasks?

  • Do you need to keep track of completed tasks for later?

  • Does complex software with a lot of options distract you?

Generally, project management software is better when collaboration and multiple tasks, subtasks, and assignments are required. Task management and to-do apps provide varying levels of complexity but are focused more on organizing yourself versus organizing a team or company goal.

When deciding which app to use, start with the 5 types of to-do apps, and pick the best one for you. Once you know the type of app you want, browse our roundup of the best to-do apps for your new favorite. Or, if you're more analog when it comes to goal-tracking, learn how you can build the perfect productivity system with paper notebooks and digital tools.

Regardless of which app you choose, try not to view all your tasks at once. Stay focused on the very next step. Setting a daily or weekly filter on your dashboard or list can help you stay on track.

2. Give your tasks visibility

Also make sure that your task data is imported into your calendar app of choice, like Google Calendar. This is an important step because it adds big-picture visibility and automated reminders.

One tip is to create a separate calendar for each goal, so you can view your tasks separately or together with your daily calendar(s). When you keep your goal tasks visible with your daily and professional tasks, it's easier to prioritize them and make room for achieving your goals.

Google Calendar
Add goal-related tasks to your calendar

3. Automate!

The good news is you don't have to spend a lot of time on this step. You can get it done in roughly five minutes with Zapier, an automation tool that connects with thousands of apps. Start by creating a new Google Sheet. Keep it blank for now and give it a name like "Goal: Write a Novel (Workflow)."

Then, in Zapier, set up a "Zap," or automated workflow, between Google Sheets, your to-do app of choice, and Google Calendar.

Once you've created your workflow, copy your entire SMART plan spreadsheet and paste it into your workflow spreadsheet and voila! Your plan will auto-populate, with the tasks from your spreadsheet automatically sent to your calendar and to-do app, so you can focus on achieving your goals, not managing them.

Overcome excuses

The hardest part of achieving a goal isn't the ideation or even the planning. It's sticking to your plan when the road gets rough.

Maybe you missed a deadline and that threw your schedule off. Maybe your plan requires more time than you realized. Maybe you're just overwhelmed.

The good news is, you can "un-slump" yourself. Read on for the three most common roadblocks to achieving your goals and how you, armed with your plan and a fresh mindset, are going to overcome them.

"There's not enough time in the day"

We'd get the promotion if we had more time for The Project. We'd have more subscribers if only we had time to write more content…and so on.

The list of excuses is endless. The truth of the matter is, every great accomplishment has been made by people within the same 24-hour day you have. What matters is not how much time you have, but how you use it.

Start by reminding yourself: you do have the time to achieve your goals. And then start making time for the things that matter.

Auto-schedule time for your goals

Michael Hyatt, noted productivity expert and author, often says, "What gets scheduled gets done." And the inverse is also true: if it's not on your calendar, you'll have a harder time doing it. So proactively blocking out time in your schedule specifically to work on your long-term goals can be a great step toward achieving them.

But too often, when we get to these precious scheduled moments, we spend our best energy deciding what to do.

Again, the goal of a SMART approach to planning is to batch decision-making, so that you can focus on the hardest part: doing. A solution that I've personally found very helpful is to automatically schedule tasks for yourself. Here's what I mean.

When I create my weekly calendar, I work in blocks of time that I know I want to spend working on my goal (in this example, writing a novel). But Monday morning is rarely the best time for me to figure out exactly how I should be using these time blocks. Instead of spending extra time on scheduling, I automate the process.

In my to-do list app, I have a special list just for this purpose. The tasks on this list are tasks that really need focus, like writing, planning, strategizing, and so on. Usually, they're also the tasks I have trouble prioritizing. I update this list every Monday morning when I'm planning my week.

Wunderlist list

On my calendar, I have appointments named "Open Focus Time Slot." Whatever you decide to name these time blocks, make sure every calendar appointment has the same name. Then, I set up a Zap that automatically schedules my tasks in the next available focused time slot.

There are three benefits to this approach that I don't find in manual scheduling.

  1. My list of "nice to get to sometime" tasks actually get done.

  2. I don't waste time pondering whether I should do Task XYZ on Wednesday or Friday.

  3. I don't leave myself the wiggle room of saying, "eh, I'd rather not do that this week/today"—what's added to my calendar is treated with the rigidity of any other meeting or appointment.

Google Calendar slots

One caveat: You may want to set up multiple lists/focus appointments for tasks that need varying amounts of time. I may need a 90-minute slot for writing 1,000 words but only a Pomodoro-sized slot for another task.

The moral of the story is: don't spend your energy on making decisions in the moment. SMART planning + smart automation = efficient use of time.

"Help! I'm overwhelmed by my goals!"

The second-most common reason people quit is that they become overwhelmed with their own goals. There's a lot of great advice out there to help you push forward when the going gets tough—like keeping a brag sheet.

I have two tricks that I've found immensely helpful and that work nicely with the SMART approach.

Tackle one day at a time

First, let's focus on the Specific, Realistic, and Time-Bound aspects of your plan. Looking at your 1-year, 5-year, or 10-year plan too often will quickly overwhelm you. Reviewing your entire SMART plan spreadsheet regularly is not the greatest idea either.

Instead, you need to trust your planning phase, update only as necessary, and then take it one day at a time. Don't start worrying about tomorrow or next month's deadline. Focus on today.

To keep my focus firmly tied to the now, I set up another Zap when I initially made my SMART plan. This Zap delays each task in my plan until the start date I defined for it. This way, my to-do items only appear when I can and should start working on them.

Measure the right things

Another reason you can get overwhelmed is that you're measuring yourself with the wrong metrics. This where the Measurable and Actionable parts of the SMART acronym come in.

Most of us measure success in terms of "lag measures." These are the desired results: the increase in customer satisfaction scores, the uptick in blog subscribers, the number of articles or books published.

The problem with these metrics, as detailed by the authors of The 4 Disciplines of Execution, is that: "When you receive [these metrics], the performance that drove them is already in the past." Lag metrics do a great job of measuring the goal, but they lack direct impact on your day-to-day behavior.

In contrast, lead measures "measure the new behaviors that will drive success on the lag measures." This form of measurement follows two criteria:

  1. It's predictive. It measures something that leads to the goal.

  2. It's influenceable. It's something that's within your power to influence or control.

Continuing my writing example, a lead measure would be writing 1,000 words every day. If I set myself a goal of "finish a first draft in three months," I become easily overwhelmed and discouraged. But breaking down my goal, I find that, if I write just 1,111 words every day (1-3 hours of work), I can hit 100k words—the average novel length—in 3 months. This metric is both predictive and influenceable, as well as easily tracked.

Save yourself a lot of stress by taking the time to break your goal into a few key lead measures—then make these actions your focus.

To keep consistency, I strongly suggest adding a sheet to your SMART plan that keeps track of these lead measures. You can do this manually if you take satisfaction from updating the metrics yourself.

Or, if your lead metrics break down into time spent in a given activity (learning a skill, perhaps), you can use a time-tracking app to track your time and automatically update your Google Sheet with your progress.

When you reach key milestones on your goal, note them in your spreadsheet, and mark how many hours it took you to meet that milestone. It'll help you better gauge your lead metrics in the future.

Need some extra motivation each day? Make your own personal best challenge bot.

"I'm so easily distracted…"

You're not alone. We live in a world where multitasking is seen as the norm and entertainment is a constant. We thrive on distraction in the modern era of instant updates and notifications—and then we wonder why we have trouble buckling down and getting things done.

In Deep Work, Cal Newport frames the problem this way:

Once your brain has become accustomed to on-demand distraction, [Clifford Nass] discovered, it's hard to shake the addiction even when you want to concentrate.

Newport's proposed solution?

Instead of scheduling the occasional break from distraction so you can focus, you should instead schedule the occasional break from focus to give into distraction.

Schedule time for distractions

At first it might sound odd, but the reason for success is quite simple: Participating in something distracting (answering email, social media, etc.) does not reduce your ability to focus. It's the constant switching between "low-stimuli/high-value" activities to "high-stimuli/low-value." According to Newport's research, our intolerance for boredom is causing atrophy in the mental muscles we need to concentrate.

In order to reverse the atrophy, he recommends we start considering our natural state as one of focus and schedule time for distracting activities. While the internet can be used constructively, he uses "the Internet" synonymously with distracting activity when he says:

Schedule in advance when you'll use the Internet, and then avoid it altogether outside these times. [...] Record the next time you're allowed to use the Internet. Until you arrive at that time, absolutely no network connectivity is allowed—no matter how tempting.

This is a principle that will take a lot of experimentation and practice to cultivate in your own life. But one tool I've found useful so far in this shift from distraction is Zapier's Digest tool, which aggregates content for you and sends it all to one place (email, Slack—you name it) at a time you designate.

This tool is a great way to mitigate the fear of missing out while staying focused, as you can channel important software and social notifications into one place while you're offline.

Digest makes it easier to cut down on the time you spend in this distraction mode, too. Your important notifications can be sorted while you focus on high-value work, and then you can quickly process what's actually important.

For example, instead of sifting through junk email and hundreds of Tweets during my "distraction breaks," I could instead check one email and see any emails from an "@mycompany.com" domain, as well as any mentions on my Twitter handle or a marketing hashtag.

Digest email

Better yet, set Zapier to release your Digests right before your scheduled distraction breaks. If you schedule your distractions in Google Calendar, this is a very simple Zap to set up.

Whatever tools you find work best for you, start practicing the principle. Make your distraction blocks as numerous and frequent as you want—the point is to start exercising your mind to approach focused work differently. Once you begin to build the habit, you'll be amazed at how much easier it is to buckle down and work on your goal.

Learn more about Zapier Digest, with some examples to inspire your workflows.


No matter the successes or failures in your past, you're capable of starting fresh and achieving your goals this year. Start with a plan. Overcome your own excuses. And dream big.

This post was originally published in January 2017 and has been updated since with contributions from Hannah Herman. Title photo by geralt via Pixabay.

Get productivity tips delivered straight to your inbox

We’ll email you 1/wk, and never share your information.

Emily Irish picture

Emily Irish

Emily Irish is a writer on the Zapier team and hails from Raleigh, NC. When not writing about productivity, she writes fiction and reads everything she can get her hands on. Follow her on Twitter @irishthewriter.

tags

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign upSee how it works