I got a question about a possible google shee...

[Adrian_Enz]

I got a question about a possible google sheet formula solution.

I got one sheet where I have my customers and I got one sheet that stores “comments” referenced on a customer. Each comment has a Timestamp.

Is it possible, in the customer sheet, to get the “comment” with the latest timestamp on each customer?

I hope it’s understandable. Thanks in advance. Adrian

[Aleksi_Alkio]

Yes you can read that value for example with the MAXROW expression. Check this article… help.appsheet.com - List Expressions and Aggregates List Expressions and Aggregates help.appsheet.com

[Adrian_Enz]

Can I use this directly in a google sheet? Because I need it executed on the fly and not only when this row changes. (Virtual Column is not a possibility because I need the value in the google table.)

Thanks a lot.

[Aleksi_Alkio]

If you need to see it dynamically, you have two choises… virtual column with the app formula or a sheet formula. If you want it to happen on a spreadsheet, you need to find a suitable sheet formula and then mark that field as read_only.

[Adrian_Enz]

Thank you Aleksi, I will be looking for a sheet formula.

[Aleksi_Alkio]

Great!