Welcome to the community, @Mike_Torrence! :grinning_face_with_big_eyes: Airtable doesn’t have an existing function that behaves like your description of Excel’s SMALL function (which I’m not familiar with, but that’s not surprising considering that it’s been at least a decade since I’ve touched Excel). That aside, I can think of at least two ways to pull this off:
Using a somewhat complex series of connections between tables (purely theoretical, though I think I’ve set up stuff like this before…or at least I’ve tried to test the theory). Pros: it’s dynamic, updating on the fly as the data updates. Cons: it’s messy, and will require at least one new table and several new fields that don’t really do anything other than support this system, though the new table might not be necessary depending on the design of your base.
Add the Scripting app and write (or get assistance to write) a script to calculate what you need and output the data where you want it. Pros: no mess. Cons: the script will have to be manually run each time you want to recalculate the smallest 8 of 20. (Note: scripts require your base to be in a Pro-plan workspace or higher, though it’s still free for Free and Plus plans until March.)
A possible third option would be deeper than #2: write (or get assistance to write) a custom app. Pros: total flexibility to make the app do what you want, and it’ll update dynamically as your data changes. Cons: custom apps take more time to develop, partly because they’re at least a couple orders of magnitude more complex than a “plain” script that the Scripting app can run.