How to add last data to virtual column?

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

And this part