Continuing the discussion from .First() not returning the first row in a sorted table : (and this may also relate to: How to access columns from a formula that returns a row? ) In my example, I have a table of grocery items I need to buy. One column is going to show me the store that I should buy t…

It works fine for me: https://coda.io/d/Demos_dOTCN5QBYBp/_sulo0 If the function is used in a formula you might have to use .value to access the store. Check the coda doc I link to and you should see an example working.

Thank you @Tomas_Jansson ! I found a suitable workaround in your solution, but I think the issue I’m highlighting still exists. First, the workaround… I updated my formula to be: =Filter(Prices,Purchase=Item).Sort(true,Price).Store.First() Notice that I referenced the column “Store” before “Firs…

Hi @Jason-Tamulonis , are you sure this is fixed? I’m currently struggling with exactly this and Coda behaves erratically. When I enter the formula it show the correct result. However once I enter/change data in the referenced table, then first/last doesn’t work at all anymore. Any tip on this?

Dear @Markus_Hofmann , welcome to the community :handshake: If possible, it will be utmost helpful to share a dummy doc to show what happens

Please have a look in the Projects overview here: First/Last Demo I’m trying to create an overview of projects. There is a second table with regular “status updates”, each getting linked to a project. This means this table will contain multiple rows per project. In the project table I’m trying to…

Dear @Markus_Hofmann , The main learning from your case is to use Max(), as we are looking for the “biggest” date [image]

Table.First() not returning a row?

Jason-Tamulonis December 5, 2019, 6:45pm 4

Hi @Thomas_Robbs I just wanted to let you know that we have fixed this issue and I’ve posted some more details here: Update: Formula Improvements - Type understanding

Topic		Replies	Views
.First() not returning the first row in a sorted table	9	1768	November 22, 2022
Cant filter rows, first row = all rows	2	161	July 8, 2024
Button "openRow" does not show the right row	2	113	June 19, 2024
Fisrt 5 Rows of table	4	832	October 23, 2021
thisRow = View.Last() does not respect sort order Bugs	4	1413	February 28, 2021

Table.First() not returning a row?

Related topics