Gigasheet’s ability to filter data has long been a fan favorite, and for a good reason! It is an efficient way for users to sort through massive amounts of data by stacking several AND and OR functions, similar to SQL queries.
In the past, filters were specified value by value, often times leading to an extensive list of functions. Well, no more! Long gone are the days of seemingly endless filter conditions. Introducing, ✨Multi-Value Filters✨.
Rather than flooding the screen with redundant filter conditions, we’ve improved the process by adding multi-value capabilities to select data types. Take multi-value filters for a spin with some sample NFL Player Data available in our Data Community.
Let’s put together your Fantasy Football dream team in under 5 minutes, including set-up, by using multi-value filters to streamline the process.
The set-up is simple:
Start by grouping the players by their current status.
Your chances of taking home this year’s Fantasy Football trophy are slim to none if you sign a retired, injured, or suspended athlete, so start by filtering out those players.
Now that we have our list of active players, we can start adding more in-depth filtering.
Let’s say you grew up in the South and want to include some players after your own heart. Rather than adding a separate line for Florida, Georgia, Tennessee, and so on, include them in a single input field.
What was once 10 lines, is now 2 lines of clean and concise filtering conditions. Here is how it could be done the slow way, using individual filters.
Next, use the grouping function to sort players by their position.
There are 2 minutes left on the clock, so spend this time playing around with other filters. Already had your Quarterback and Offensive Linebacker picked out? No worries, filter out those two positions. Filter to include players who went to your alma mater, or more importantly, exclude players who went to the rival school.
And… TIME! Now that you have your dream team, let’s recap the steps we took to get here:
Join our newsletter and be the first to know when we release exciting new additions to our filter tool. If you think multi-values are great, you will LOVE what we have up our sleeve next!