Hi guys, not sure if to make a new post about this or continue writing here. So based on the questions from before, I have a comments field in column F of the "Data" table and I want these comments same as before to be shown in the Inventory list in a separate column next to the one showing the "borrowing status". I've tried adapting the formula from before, but the issues is that I am getting only one word from the comments and I am not sure how I could make it pull the entire comment.
This is my formula at the moment:
Formula:
={"Bemerkungen";BYROW(A2:A,LAMBDA(items,IF(items="",,IFERROR(INDEX(SPLIT(INDEX(SORT(FILTER(Data!A:F,Data!D:D=items),1,0),1,6)," "),1,1)," "))))}
Bookmarks