Formula column where all row values are a certain column value matching another column
I have a table like thisand want to create a new formula column (reference size fruit) where the row value is the value to the Column "Size", but with the condition that the order is 5 and the value updates for each fruit type.E.g., the result should look like this: I can do it using a nasty workaround (marking 5 in column "order", select matching values, do a subset using selected rows and update...