0:00 So, an interesting problem here is that we have, let's say, stores that we're selling pallets of paper to, and we have sales reps that we want to align with each of these stores, but we have multiple sales reps.
0:13 What we can use is the new function of allow multiple selections in our dropdowns. We can create a dropdown here, and we can put in Andy as a sales rep.
0:24 We can put Dwight, and we can add Jim. We can color code these as well. Andy, Dwight, and Jim. And we can select that to be the entire column B.
0:38 We will need to select allow multiple selections over here on the right bottom side. Click done. Close that for now.
0:47 And we can select, say, Andy, Andy, Andy, and Dwight. And then we can select something like Jim and Dwight and then Jim now maybe during our, uh, analysis of this, we want to know, you know, how, which stores is Andy assigned to?
1:09 Well, we could have created like Andy. We can go equals filter. We'll filter the range. And usually what we used to do is just say the B column is equal to Andy.
1:28 And you'll see here that this will result in, The result is paper pillows and the right stuff, but it doesn't include parchment pros because there's Andy and Dwight here.
1:36 Now, this never used to be a problem because we did not have this allow multiple selections. But now that we do, it offers an interesting, there is an interesting solution to this.
1:49 And what we can do is instead of having this, condition be an equals, we use search formula and we're going to search for Andy.
2:09 Where are we going to search for? It's going to be in the B column. And now we include everything that includes Andy here.
2:16 Well, let's see if we can create Andy's total sales as well, like the total pallets sold. We can. We can use the exact same filter here.
2:27 We can't use the exact same filter, but instead of filtering the A column, we're going to filter the C column and we will get numbers, but we're gonna sum them up.
2:43 So let's just wrap that with sum and we get the total sales. So this is Andy's total sales. And with these new formulas, with this search and this filter, we can use this allow multiple selections very easily, very well, and we can create dashboards.
3:01 Or summaries of this information or analyze it for our purposes as we go. We can see these will change if we add Andy here, we can actually flip these around a little bit there and we can keep adding Dwight and Andy and it'll show up in Andy's.
3:22 So I thought that was really cool. Again, it's just this adding this search into the filter instead of using that equals condition.
3:28 Thank