Functions not yet in Grist (SMALL, RANK)

Grist Feedback
1

Where can I follow which funtions from Excel/Calc are beeing developed and introduced to Grist? There are still some not implemented. Particulary I’m interested in the ‘SMALL (data, n)’ and the ‘RANK (value, data, is_ascending=None)’ functions, as I’m trying to build a Golf handicap calculation table for our local players, and embbed it in our Website, with a dynamic table. I can still do my calculations in Calc and just upload the results, but it would be nice to be able to do it all in Grist.

Thank you.

2

The list of available functions is here.

Missing functions may be replaced by python code (replace capitalized names by your values):

SMALL (this one is quite concise, but not the most optimized one if you have a big referenced table):

list(set(REFERENCED_TABLE.lookupRecords(sort_by="COLUMN").COLUMN))[N-1]

RANK:

data = REFERENCED_TABLE.lookupRecords(sort_by="COLUMN").COLUMN
len(data) - data.index(1)
3

Thank you very much. I will look into it.