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 the item at, because in another table, I have all of the prices of all of the groceries and the corresponding store to buy it from.
In this column, I’d like to get the name of the store corresponding to the lowest price I have in the Prices table - something like:
- Prices is my table of Purchases, each with a Price and Store
- Item is the name of the item that I need to purchase
My problem here is that First() doesn’t seem to return what I think it should, a single row from the Prices table. As such, I can’t reference “Store” on the row from Prices that is returned, even though looking at the results of First (via hover in the formula editor) shows me the full information about the single row.
What am I missing here? Why can’t I append the column name to First and have it give me the value of the column as I’d expect?