Hello everyone!
I am using appsheet for tracking productivity of my cows.
a few month ago I have bought weight scale.
We are scale cows every traetment, so in my sheet I have records with same cow id but different date and weight.
Now, I want to get last weight of cow and show in common table.
How can I get last weight by date in virtual column ?
Weights saved with cow ID, so I can get weight by cow ID, but I don’t know how do that
Hi @sayan
Check out this post
[FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216) Tips & Tricks ?
Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…
And this part
