Finding the sum of the smallest three numbers in an array

[Samer_Adeeb]

I have a rollup field (or lookup field) that usually contains an array of 8 numbers. I would like to have a formula that gives the sum of the smallest three numbers. Right now, it seems that it is impossible without an external application (Zapier). Are there any array formulas that would help me to achieve that? Note that these are numeric values and don’t necessarily have the same “length”.

[Justin_Barrett]

Welcome to the community, Samer! :grinning_face_with_big_eyes: Airtable’s current array operations are fairly limited, I’m afraid. If Airtable arrays could be sorted and indexed, this would be a piece of cake. As it stands now, you’re left to (figuratively) make your own cake from scratch using third-party ingredients.

[AlliAlosa]

@Justin_Barrett is correct - unfortunately there’s no way to sort arrays inside of Airtable at the moment… making this task very difficult. I know you said you don’t want an external application, but if you end up having to go that route… @Mike_McLaughlin managed to get this done using Zapier. See the below reply for how to do it!

Sum of Max or Min values in an array Formulas

Well, i worked out how to do this with a Zap, but 2 downsides, 1) zap has more than 2 steps, so you need to get a paid plan for past the trial period, 2) only auto-runs every 5 minutes. [image] [image]