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.
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 objects that you own, your team owns, or anyone in your organization owns.
From there, you'll have the ability to add as many filters as desired.
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 Tooltip button found in the top-right corner of the filters dialogue box, and click Enable filter groups.
Once enabled, you'll find the Add filter group option available once at least one filter has been added.
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.
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 the pipeline based on the 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 and 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.
Do you have any questions or want to learn more? Feel free to contact our Technical Success team at support@people.ai!