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

(Adrian Enz) #1

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) #2

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) #3

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) #4

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) #5

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

(Aleksi Alkio) #6

Great!