Hello
I used the formula below and it works OK but it takes too many resources to calculate. I assume using Tables will prevent that as it will not have to search across the whole sheet since it will only search across the Table.
=TEXTJOIN(CHAR(10),,FILTER(Sheet1!$I:$I,(ISNUMBER(SEARCH([@[ID]],Sheet1!F:F)))*(Sheet1!B:B<=[@[Date 2]])*(OR(ISBLANK(Sheet1!D:D),Sheet1!D:D>=[@[Date 2]]))))
I tried to use Table references to make it work but it doesn't seem to work:
=TEXTJOIN(CHAR(10),,FILTER(Table2[@Text],(ISNUMBER(SEARCH([@[ID]],Table2[@LB])))*(Table2[@[Date 1]]<=[@[Date 2]])*(OR(ISBLANK(Table2[@[Date 3]]),Table2[@[Date 3]]>=[@[Date 2]]))))
Any idea why it does not work?
I think the problem is at the Table2[@Text], because it seems to refer to a specific row under this column, instead of the whole column.
However, I am not sure how to make it consider the whole column instead.
Thanks!
I used the formula below and it works OK but it takes too many resources to calculate. I assume using Tables will prevent that as it will not have to search across the whole sheet since it will only search across the Table.
=TEXTJOIN(CHAR(10),,FILTER(Sheet1!$I:$I,(ISNUMBER(SEARCH([@[ID]],Sheet1!F:F)))*(Sheet1!B:B<=[@[Date 2]])*(OR(ISBLANK(Sheet1!D:D),Sheet1!D:D>=[@[Date 2]]))))
I tried to use Table references to make it work but it doesn't seem to work:
=TEXTJOIN(CHAR(10),,FILTER(Table2[@Text],(ISNUMBER(SEARCH([@[ID]],Table2[@LB])))*(Table2[@[Date 1]]<=[@[Date 2]])*(OR(ISBLANK(Table2[@[Date 3]]),Table2[@[Date 3]]>=[@[Date 2]]))))
Any idea why it does not work?
I think the problem is at the Table2[@Text], because it seems to refer to a specific row under this column, instead of the whole column.
However, I am not sure how to make it consider the whole column instead.
Thanks!