27. June 2022

Interactive GRID features for engaging teamwork  

GRID was built for interactive exploration. So when you consider ways to engage your team or better communicate spreadsheet data across your organization, GRID may just have the perfect combination of features for you. Smart, collaborative, and easy to share, interactive GRID reports and models can actively help to align your team and build cohesive understanding across departments.

1. Buttons

These little beauties are as easy to use as they are versatile. Buttons set a target cell or range to a defined value and can be used to increase or decrease that value, generate random values within a given range, and a multitude of other actions. In this lottery odds calculator & simulator a button is used to recreate the behavior of a random number generator with the RANDBETWEEN function. This can also be achieved by adding a Recalculate button to initiate a recalculation of random values.

Lottery GIF 2

Include a Reset button to let your team members return a GRID doc back to its default values. Knowing that they can simply switch back to the original scenario will help everyone feel more confident in exploring all the possible outcomes of the model.

Radio buttons are slightly different in that they offer viewers a short list of options to choose from. If we’d like to view the difference between annual paid and organic signups in our marketing report, radio buttons make it easy to see the numbers for each option without having to go back and forth between charts or make changes to the underlying spreadsheet model.

2. Input Fields

Alright, so no one said that input fields were the most thrilling of elements, but this easily underestimated feature can actually help you perform pretty nuanced analysis.

input field gif

Since input fields allow for direct input of a value to a target cell and can be formatted to increase or decrease that value incrementally, they’re an open invitation for your colleagues, executive team, or board of directors to interact with your model.

Let’s say that your Growth team needs feedback on a SaaS user retention model. Your company’s Finance team can jump into the model, input certain values, and find out how these factors might affect the numbers of new and retained users. Everyone involved arrives at a clear decision.

3. Dropdown selections

Dropdown selections set the value of a target cell based on a range of available options defined in your spreadsheet. In this Break-even analysis, the dropdown selection lets you view total cost, total revenue, and profit/ loss for each of three products in the line chart, as well as their combined total. If you implement hierarchical selections using the FILTER or UNIQUE function with your dropdown selections, this feature gains even more specific capabilities.

Dropdown selection

4. Checkboxes

Checkboxes let viewers select one of two available values/options and can be useful in helping viewers navigate data. In GRID, they’re great for controlling the visibility of specific charts, text blocks, or even entire columns in your documents.

In this Saas KPI dashboard template, we’ve added checkboxes to each column, making it possible for viewers to see more detailed charts and information when they select the checkbox. Apply this method to blocks of data narrative, images, or almost anything else you can think of.

5. Sliders: everybody's favorite

You might be surprised by how powerful a single slider can be when used in conjunction with a complex model like a scatter plot. This stunning, GRID-built recreation of Hans Rosling’s “Bubbles” animation at TED 2006, allows viewers to easily navigate through a complex set of chronological data — all thanks to a slider.

Multiple sliders invite a beautiful interplay between viewers and the model they’re interacting with. The use of more than one slider exponentially increases the precision with which you can define values, helping your team assess projections, for example, at any level of nuance.

If you’re working with a large number of variables, sliders are the perfect element to encourage independent exploration. Give your board members the chance to assess a project in their own time, manipulate the range of options, and arrive at a decision without needing to request further information or analysis.

This company valuation template employs 11 sliders representing a variety of assumptions, and shows sliders and input fields working in tandem to facilitate both specific analysis based on input values and exploration of possible outcomes.


Building better customer relationships

Interactive GRID features are extremely effective in enabling collaborative analysis — especially when used in combination. But the bottom line? They’re an awesome way to support strategic decision-making. Align your team, department, or perhaps even your entire organization through a deep and collective understanding of the numbers.

More blog posts

04. November 2021

Introducing Conversations: a new way to explore & explain data

We’re thrilled to announce the launch of Conversations, a game-changing new feature designed to facilitate communication and collaboration in context.

23. March 2021

GRID launches empowering spreadsheet-to-web software 

We’re launching our revolutionary spreadsheet-to-web tool that will give superpowers to spreadsheet users around the world!

06. March 2018

Your biggest competitor is a spreadsheet

If you are in the software industry, odds are that your biggest competitor is a custom spreadsheet created by your...

14. December 2018

The 20 Best Spreadsheet Quotes

We've deep dive into the world of spreadsheets and come across a lot of insightful, witty and distressing quotes. Here...

31. July 2019

Spreadsheets, we have a problem!

GRID is built to allow spreadsheet users to make even more of their spreadsheet skills and assets by overcoming some of...

28. August 2018

Excel vs. Google Sheets usage — nature and numbers

One of the most common questions I get is if Excel is still important, implying that “everybody” must be using...

31. March 2019

The business world’s love/hate relationship with spreadsheets

Business people need to get stuff done, and they don’t have the time to involve the IT department or go...

25. November 2019

Spreadsheets lack people skills 

Spreadsheet is rarely built to be used only by its’ author. Spreadsheets are frequently shared or their findings reported on.

07. May 2019

The Case for Modern Productivity Tools

Startups are approching the market from a diffirent point yet they are unified by utilizing people's exsiting skills and knowdledge...