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".
Solved! Go to Solution.
A solution that works:
"• " & [Task 1]
& IF([Task 2]= "N/A", "", "• " & [Task 2])
& IF([Task 3]= "N/A", "", "• " & [Task 3])
|
|
& IF([Task 10]= "N/A", "", "• " & [Task 10])
Good Solution:
Do not use columns as a list, but instead have a Tasks table with relevant table references. In this case your expression will be a single line:
SUBSTITUTE([Related Tasks], " , ", " • ")
A solution that works:
"• " & [Task 1]
& IF([Task 2]= "N/A", "", "• " & [Task 2])
& IF([Task 3]= "N/A", "", "• " & [Task 3])
|
|
& IF([Task 10]= "N/A", "", "• " & [Task 10])
Good Solution:
Do not use columns as a list, but instead have a Tasks table with relevant table references. In this case your expression will be a single line:
SUBSTITUTE([Related Tasks], " , ", " • ")
Thanks for the help, appreciate it!
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |