How to Add Trend Arrows in Google Sheets

Showing how data changes over time is fundamental to any report, but a plain table of numbers can make it hard to spot what really matters. Adding simple up and down trend arrows is a fantastic way to make your Google Sheets reports instantly scannable, guiding your team’s eyes to what’s working and what isn’t. This guide will walk you through a few practical methods for adding these powerful visual cues to your spreadsheets.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Use Trend Arrows in Your Reports?

Before jumping into the how-to, it helps to understand why these little symbols are so effective. Trend arrows aren't just for decoration, they serve a distinct purpose in data visualization and reporting.

• At-a-Glance Insights: A green up arrow next to your revenue number is universally understood as "good." A red down arrow next to website sessions is "bad." This immediate visual feedback saves busy stakeholders from having to compare numbers and interpret the change on their own.
• Improved Readability: Large datasets can be overwhelming. Arrows break up the monotony of numbers, making tables and dashboards less intimidating and easier to navigate. They help create a visual hierarchy, drawing attention to the most significant changes first.
• Professional Polish: Simple touches like trend indicators elevate your report from a basic data dump to a professional-looking dashboard. It shows you've thought about how the audience will consume the information.

Method 1: The Classic IF Function with Unicode Symbols

This is the most flexible and widely used method for creating trend arrows. It gives you full control over the appearance and allows you to easily combine the arrow with other data in the same cell. It might seem technical at first, but it's based on a simple, logical principle.

Step 1: Get Your Arrow Symbols

First, you need the actual arrow characters. You're not inserting images, you're using text characters that look like arrows. The easiest way to get them is to simply copy and paste them from here:

• Up Arrow: ▲
• Down Arrow: ▼
• Neutral/Sideways Arrow: ► or –

Keep these handy, as you'll be pasting them directly into your formula.

Step 2: Set Up Your Data

Let's imagine you're comparing website traffic for this month versus last month. Your data might look something like this, with columns for the previous period, the current period, and an empty column where our arrows will go.

Example Data Setup:

• Column A: Page Name (e.g., "Homepage," "Pricing Page")
• Column B: Last Month's Sessions
• Column C: This Month's Sessions
• Column D: Trend (This is where our formula will live)

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Write the Nested IF Formula

The IF function in Google Sheets is your best friend here. It checks if a condition is true, and then returns one value if it is, and another value if it's not. The basic structure is IF(condition, value_if_true, value_if_false).

Since we have three possible outcomes (up, down, or no change), we'll need to "nest" one IF function inside another.

Here's the logic in plain English:

1. Check if this month's sessions (C2) are greater than last month's (B2).
2. If they are, show the up arrow "▲".
3. If not, then run another check: are this month's sessions (C2) less than last month's (B2)?
4. If they are, show the down arrow "▼".
5. If neither of those is true, it means the numbers are equal, so show the neutral arrow "►".

Translated into a Google Sheets formula in cell D2, it looks like this:

=IF(C2>B2, "▲", IF(C2<B2, "▼", "►"))

Type or paste this formula into cell D2 and press Enter. Then, click on the small blue square in the bottom-right corner of the cell and drag it down to apply the formula to the rest of your rows. Voila! You now have a column of trend arrows.

Making Your Arrows Pop: Adding Color with Conditional Formatting

Black and white arrows are helpful, but color-coded arrows are even better. Green for up and red for down is an intuitive standard that instantly communicates performance. Here’s how to apply color using Conditional Formatting.

Step 1: Select Your Arrow Column

Click on the header of the column containing your trend arrows (e.g., column D) to select the entire column.

Step 2: Open Conditional Formatting

In the menu, go to Format > Conditional formatting. A sidebar will appear on the right.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Set Up the "Up" Rule (Green)

In the Conditional format rules sidebar, under the "Format cells if..." dropdown, select "Text is exactly." In the value box that appears, paste your up arrow: ▲.

Under "Formatting style," click the paint bucket or font color icon and choose a nice shade of green. Click "Done."

Step 4: Set Up the "Down" Rule (Red)

Now, click "Add another rule." Repeat the process for the down arrow:

• Format cells if... "Text is exactly"
• Value: ▼
• Format style: Choose a red font color.
• Click "Done."

Step 5: Set Up the "Neutral" Rule (Optional)

If you want to style your neutral arrow, add one more rule for the "►" symbol, perhaps formatting it with a gray or yellow text color to make it visually distinct but less prominent than green or red.

Now your report is not just functional but also visually striking and easy to interpret.

Method 2: Using Built-in Icon Sets

For a quicker, more automated approach, Google Sheets has built-in Icon Sets within its Conditional Formatting tool. This method requires a helper column that calculates the raw change between the two periods.

Step 1: Calculate the Numeric Change

Insert a new column (let's say column E) and call it "Change." In cell E2, enter a simple formula to calculate the difference between this month and last month:

=C2-B2

Drag this formula down. You'll now have a column of positive (growth), negative (decline), and zero (no change) numbers.

Step 2: Apply the Icon Set

1. Select the "Change" column (column E).
2. Go to Format > Conditional formatting.
3. Under the "Format style" dropdown, choose Icon Sets.
4. Select a set that includes up, down, and sideways arrows.
5. Google Sheets will automatically configure the rules, but you can fine-tune them. The default is typically correct for this use case:
6. Pro Tip: If you only want to see the arrows and not the numbers, check the "Show icon only" box. This leaves you with a clean, icon-only column perfect for dashboards.

This method is incredibly fast but offers less flexibility. For instance, you can't easily combine the icon with a text value in the same cell.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Advanced Technique: Combining Arrows and Values in a Single Cell

For ultimate efficiency, you can merge your trend arrow and the actual performance number into a single cell. This saves space and puts the most important information right next to its directional context.

We'll achieve this by modifying our original IF formula and using the ampersand (&) symbol to concatenate (or join) the arrow with the numeric value.

Let's say you want to show an arrow next to the percentage change. The formula in our trend column (D2) would now look like this:

=IF(C2>B2, "▲", IF(C2<B2, "▼", "►")) & " " & TEXT(ABS((C2-B2)/B2), "0.0%")

That looks complicated, so let's break it down:

• IF(C2>B2, "▲", IF(C2<B2, "▼", "►")): This is our familiar nested IF formula that outputs the correct arrow.
• & " ": This joins our arrow with a space for readability.
• TEXT(..., "0.0%"): This function converts a number into text with a specific format. Here, we need it to display our calculation as a clean percentage.
• ABS((C2-B2)/B2): This is the math part. (C2-B2)/B2 calculates the percentage change. We wrap it in ABS() (Absolute Value) because we want the number to always be positive, the arrow already tells us the direction.
• "0.0%": This is the format we're telling the TEXT function to use.

The result in your cell will be a thing of beauty, like "▲ 15.2%" or "▼ 5.8%". You can then apply the same red and green conditional formatting rules from before to this combined cell.

Final Thoughts

Adding trend arrows transforms a static Google Sheet into a dynamic, easy-to-read report. Whether you prefer the granular control of IF formulas or the quick setup of built-in Icon Sets, these visual indicators help anyone, from teammates to executives, understand business performance in a single glance.

Manually creating these reports works, but it often involves the recurring chore of exporting data, checking formulas, and updating your sheet just to see the latest trends. From our experience, we know how much time that process can take away from actual analysis. We built Graphed to solve this by connecting directly to your live data sources like Google Analytics, Shopify, or Salesforce. Instead of building formulas, you just ask in plain English for a report showing "month-over-month session trends with arrows," and a real-time dashboard is created for you in seconds, always staying up-to-date automatically.