Skip to main content
Using Sheet Filters
Updated over a week ago

Overview

Filters on PeopleGlass Sheets are highly intuitive, responsive, and enable users to sift through huge amounts of CRM data within seconds.

How it Works

Filters are available from any Sheet via the Add Filters button, which is found next to the Sheet search box.

filter.png

From the filters dialogue box, start by selecting the scope of the data you'd like to see. For example, you can set your Sheet to show only CRM object that you own, your team owns, or anyone in your organization owns.

filters3.png

From there, you'll have the ability to add as many filter as desired.

filters2.png

Add a filter by selecting the field you'd like to use, then the operator (is, is not, is more than, is less than, etc.), and finally, the filter value.

Filter Groups

Filter groups provide the ability to group filters by AND/OR logic.

To access filter groups, click the

My_Cases_2022-08-10_at_3.18.22_PM.jpg

button found in the top-right corner of the filters dialogue box, and click Enable filter groups.

filters4.png

Once enabled, you'll find the Add filter group option available once at least one filter has been added.

Image_2022-08-16_at_17.37.16.png

At the bottom of the filter pop-up box, a numerical value is displayed highlighting the number of records to be returned based on the filter criteria entered.

Filter Results

As you add and edit filters, the number of results your filter configuration will return will update in real time in the bottom-left corner of the filter dialogue box.

filters5.png

Grouping Filters

Grouping helps you organize pipeline data more efficiently by grouping opportunities, accounts and other objects, and automatically calculating subtotals. It’s designed to give you a clearer view of pipeline based on grouping you choose.

You can group opportunities by individual AEs, forecast categories, or other relevant columns (e.g., region, product). We will display opportunities according to the selected grouping. For example, quickly organize opportunities by Forecast category to get a better sense of pipeline state.

Toggling Views

Toggle between collapsed or expanded views of your groups, making it easier to navigate large datasets.

Subtotal Calculations

See subtotals for pipeline value, forecasted revenue, and more, so you can better understand the impact of each group.

Quick Filters

Apply a filter directly from a table cell to quickly drill in and inspect all records with a specific value. These filters are displayed differently from standard filters and can be toggled on and off without affecting the core filter set. Note that quick filters will not be saved across sessions such as refreshing the page or opening in a new tab.

---

Have more questions on PeopleGlass? Reach out on Intercom using our app.

Did this answer your question?