find the most recent value in a sheet column

[Greener_Power1]

how do I get a virtual column to return just the most recent value from a column 

[yasarcan]

Hi

https://support.google.com/appsheet/answer/10107920?hl=en

[Greener_Power1]

Hi,

Thanks for the reply, however, Max() returns the highest value, not the last value added, i need to return the last entry in a balance column

[baba_sawane · Accepted solution]

https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-FILTER-LOOKUP-MAXROW-MINROW-REF-ROWS-and-SEL...

[TeeSee1]

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Select-value-depending-on-latest-date/m-p/52701...

[Gustavo_Eduardo]

First, you need a field to store a date, time or timestamp. This will allow you to track the temporal location of the record. For instance, if there's a record in your table created today at 10:00 AM, then today's record is the most recent one.

You can obtain this data manually by inputting the timestamp through a form or by using a "change timestamp" feature that automatically stores a timestamp whenever a new record is inserted.

Alternatively, you could consider the "most recent" record as the last one inserted. Regardless:

Once you have this data, I would suggest creating a virtual column to store the ID of the most recent record. This could be the one with the most recent date or the last row in the table that meets certain conditions.

Puedes usar MAXROW() 

Once you have the ID, you can dereference it to get the desired column related to that data.

[Greener_Power1]

Thank you all, solved really appreciate the help