Functions not yet in Grist (SMALL, RANK)

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.

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):



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

Thank you very much. I will look into it.