A Rank() function for expressions

[Kirk_Masden]

There are several ways in which I would like to use a rank() function in my app but, since such a function is not available in AppSheet, I need to do it on the spreadsheet side. This, however, makes syncing necessary. It would be nice to have a rank() function that could be used in a virtual column.

[Steve]

What would RANK() do?

[Kirk_Masden]

They way I use it in my app is as follows. First, records are shuffled in to a random order using RANDBETWEEN(). This, of course, is also available in AppSheet. Then RANK() lets me determine which record is next and which is previous to a give record after the sorting.

Actually, I discussed this with @praveen quite some time ago and, as I recall, he agreed that RANK() would be necessary to do what I wanted to do (though I don’t recall that he felt RANK() is necessary for AppSheet – what I wanted to do was a bit unusual). I looked for that discussion in the archive but it seems that we can only search back to the beginning of 2018. That is a disappointment. I was under the impression that the entire archive would be saved.

[Steve]

This?

support.office.com

RANK function

This article describes the formula syntax and usage of the RANK function in Microsoft Excel.

[Kirk_Masden]

Yes. That’s what I’m using in my spreadsheet. If I had it in AppSheet, I’d like to see if I could make my app do what it is already doing more efficiently.

[Jkr_Ckmnt]

Im also need this. Previous use in ms excell but i dont know how to use in appsheet. It is still not available for now?

[Steve]

This? Click through the link…

Get the index number out of list Questions

You gave me a great guide. I placed your expression as it it, to my sample app, but unfortunately it does not work. After playing around a bit, I found why it does not work, and twisted a expression a bit. Great new is revised expression finally did a job! This is expression. count( SPLIT( Left(TEXT([text val]), FIND( [text val] , TEXT([list]))+len([list]) ), " , " ) )