Hi, I hope you can help. Background - I have an excel spreadsheet that I have imported. It contains golf scores for a group of friends. I have logic/formula in the Excel spreadsheet that is not supported in Appsheet so I am looking to use Appsheet expressions to recreate them.
I have a ‘scores’ table imported from Excel with 20 rows (fixed) per person. Here are 2 of the things I would like to do, I appreciate there is always more than one approach.
I want to create a slice (single row of data) of the oldest row per person [selected by date, person] to be updated via the app. (I dont want the other 19 rows per person to be updated). I’ve looked at SELECT, MINROWS etc. For info, In Excel I used an IF/SMALL [date] function on an array.
My 2nd problem is similar - I want to create a slice to select the lowest 8 [scores] of the 20 scores per person. Again, I had this flagged in Excel using an IF/SMALL (8) [score] function on an array but it’s not supported when imported.
Any help is greatly appreciated.
Many Thanks, Ian