Just Launched! — Build Custom Worksheet Equations Using Any Data in Aha!

Product teams were excited when we recently launched custom worksheets. Why? Because of the flexibility to add any type of data (such as financial metrics) to records in Aha! and run calculations. This means, for example, you can estimate feature costs or track the ROI of a product launch. And with today’s enhancement, you can do a lot more.

You can now reference any standard or custom field in custom worksheet equations — so you can perform powerful data analysis using data from anywhere in your account.

Custom worksheets are available for customers on our Enterprise+ plan. This plan is ideal for complex organizations that demand the most sophisticated capabilities and a hands-on level of support from our concierge team. It also includes advanced security and backup features, as well as ongoing training services.

If your product and marketing teams were already using custom worksheets, then you know that previously you could only include custom worksheet fields in your calculations. Some of you told us that it would be helpful to reference data from anywhere in Aha! in your worksheets, so you can answer complex business questions. Now you can.

The syntax for referencing Aha! fields in custom worksheet equations can be complex. Which is why we created a detailed support article that explains exactly how this functionality works and provides some sample equations for common use cases. But if you need more help getting started or want to upgrade to the Enterprise+ plan, just reach out to our Customer Success team. We would be glad to help you get the most out of this advanced functionality.

Note that you must be a customization administrator to create custom worksheet fields and add equations. Product and marketing owners and contributors can enter data in worksheet fields, while all users can view the data.

This enhancement provides enormous flexibility, so we wanted to share two examples of what is possible:

Prioritize features using vote count and score
You want to find the highest priority features based on customer demand and strategic fit, right? In the example below, we created a custom worksheet equation that references two existing fields in Aha! — vote count and feature score. Multiplying these fields provides a total prioritization score to better inform your roadmap decisions.

The total prioritization value automatically updates if the vote count or feature score changes.

Automatically calculate the total cost of initiatives
Next, you want to track the overall investment needed for your product initiatives. If you already use Aha! to calculate the cost of each feature, you can create a custom worksheet equation at the initiative level that sums the total cost of all linked features. This helps you project the anticipated spend for your strategic initiatives.

You can include all custom worksheet data in reports and charts.

Custom worksheets are a powerful way to analyze your product and marketing planning data.

This kind of sophisticated data analysis most benefits large enterprises with complex product portfolios and go-to-market strategies. If your organization would find custom worksheets useful, let us know. We would be glad to help you get started.

Upgrade your Aha! plan to Enterprise+
Custom worksheets are available for Enterprise+ customers. If you are an Enterprise+ customer, we can help you get started using worksheets today. If you are not an Enterprise+ customer and would like to learn more, send a quick note to support@aha.io. A member of our Customer Success team will respond to your request (usually in less than two hours) and share more about the benefits of the Enterprise+ plan.

About Claire and Aha!

Claire is passionate about helping product and marketing managers set brilliant strategy and deliver results. She is a Sr. Product Marketing Manager at Aha! — the world’s #1 product roadmap and marketing planning software. Claire has more than 15 years of marketing and software experience. Previously, she led product marketing at an agile-based work management platform.

Sign up for a free trial of Aha! and see why more than 250,000 users worldwide trust Aha! to set brilliant strategy, capture customer ideas, create visual roadmaps, and manage breakthrough marketing programs.

We are rapidly growing and hiring!

  • Customer Success Managers (product manager experience required)
  • Product Marketing Managers
  • UX Designers
  • Rails Developers

Work from anywhere and be happy. Learn about our team — see current openings.

Leave a Reply

Your email address will not be published. Required fields are marked *