Forum Discussion
Solved
Need to build a string based on conditions
I have need to scan various columns of data within a table and, depending on certain criteria, extract a field. Something like SUMIFS, except extracting and concatenating strings rather than extracti...
It could be
=TEXTJOIN(",",TRUE,IF(Booth_TBL[Company]=[@Company],Booth_TBL[Booth Label],""))if we speak about Booth Number(s) column
much more helpful to upload a sample of the spreadsheet you're working with, and perhaps an example of what you want the function to extract from a few columns in the real sheet. Otherwise we're all just dealing with an abstraction