Combination Formula

[JuneCorpuz]

Hello-

Has anyone tried to do same formula in AppSheet? My client needs a combination formula in his app. Attaching a screenshot for a sample calculator I found in the net.

[Marc_Dillon]

I suppose you could replicate a factorial function with a decrementing value in a “Looping with Actions” setup.

Looping with actions Tips & Tricks 💡

Kinda burnt out and just wanna get this out. I’ll try to circle back later and provide some documentation. https://www.appsheet.com/samples/Examples-of-loops-using-actions?appGuidString=7b9ae746-1f51-4ecb-8c...

[JuneCorpuz]

Thank you for your suggestion Marc! I will try this one.

[JuneCorpuz · Accepted solution]

Hey Marc. It’s hard to replicate the combination formula by using the loop actions. I created a table instead and perform a lookup to get the value. See sample below.

Combination	Value
2	1
3	3
4	6
5	10
6	15
7	21
8	28
9	36
10	45
11	55

and so on…

[Marc_Dillon]

Yah, a lookup table, I agree that’s way easier. I’ve made a lookup table for trig functions for another app.