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
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
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.
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.
Thank you Aleksi, I will be looking for a sheet formula.
Great!
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |