Hello I had a question, well actually 2. The first one is in the following expression:
CONCATENATE(
“• “;[Task 1],”
“,IF([Task 2]<>“N/A”,[Task 2],””),"
“,IF([Task 3]<>“N/A”,[Task 3],”“),”
“,IF([Task 4]<>“N/A”,[Task 4],”“),”
“,IF([Task 5]<>“N/A”,[Task 5],”“),”
“,IF([Task 6]<>“N/A”,[Task 6],”“),”
“,IF([Task 7]<>“N/A”,[Task 7],”“),”
“,IF([Task 8]<>“N/A”,[Task 8],”“),”
“,IF([Task 9]<>“N/A”,[Task 9],”“),”
“,IF([Task 10]<>“N/A”,[Task 10],”"))
How do I get the dot • to add onto the beginning of all the other column values as well as a text value attached onto the column value? Whenever I tried what I did for Task 1, it either showed the dot and not the column value or the other way around. Also when I look at this in the Ref view it shows blank lines if the criteria is met so how do I remove all the blank space? Such as the Organize Data into sensible chunks part? It doesn’t remove the space once it has been filtered, which nothing I have done to get rid of it works unfortunately. I wanted the value to not show including the blank space if it equals “N/A”.
