Hi
I am trying to explore Airtable now to see if it can do what I was able to do with Google
sheets ..hopefully better.
There does not seem to be a way to select multiple records and then search through those records.
For example in the following example I want to select all the records that match Utah. Of those 3 records I want to find the record with the lowest number in the Monthly Leads to date column.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/2282866b-11fa-41e7-9fb1-7f26f61d5fef.png)
Any advice would be appreciated.
Thanks
Galen