LOOKUP LATEST VALUE, NOT RANDOMLY CHOSEN

[juanconsuela123]

Hi,

I was having a problem with lookup values where the return value is the first row of data.

I would like to have the result where the [STATUS] is in lookup order, starting from "UNFINISHED" , "FAILED", and finally "FINISHED"

Any help is appreciated, thank you

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2357314-select

https://help.appsheet.com/en/articles/2357312-orderby

https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216