Hello there. I am trying to create a custom column based on the values entered other columns within a row.
For example, I want to get any combination of “Phone”, "SMS, "Email and “Post”, depending on whether the relevant columns are TRUE. IN the screenshot above, for example, row 11 would show in the custom column as Phone,SMS,Email and row 14 would be null (none of the Marketing columns are TRUE.
I have only got as far as being able to return one value in the custom column; I seem to be struggling with the combining. Does anyone have any pointers, please? I suspect it isn’t that difficult, but it is not something I have ever had to do so far, so don’t quite know how to do it.
eDNA query.pbix (3.6 MB)
File attached.
Many thanks in advance.
