Line break to remove if column is blank

AppSheet AppSheet Q&A
1

My current expression is
CONCATENATE(
if(isnotblank([WASHING]),Concatenate(Washing," - “,[WASHING]),”“)&”
“&
if(isnotblank([DAMAGE]),Concatenate(Damage,” - “,[DAMAGE]),”“)&”
“&
if(isnotblank([Road Fare]),Concatenate(Road,” - “,[Road Fare]),”“)&”
“&
if(isnotblank([Others]),Concatenate(Others,” - “,[Others]),”")
)

For Mr.Steve.jpg
For Mr.Steve.jpg781×1146 57.1 KB

2

Try this:

CONCATENATE(
  IFS((0 <> [WASHING]), ("Washing - " & [WASHING])), "
  ", IFS((0 <> [DAMAGE]), ("Damage - " & [DAMAGE])), "
  ", IFS((0 <> [Road Fare]), ("Road - " & [Road Fare])), "
  ", IFS((0 <> [Others]), ("Others - " & [Others]))
)
1 Like
3

Line break was still there.

For Mr.Steve 2.jpg
For Mr.Steve 2.jpg338×507 12.4 KB

1 Like
4

Whoops! I misunderstood. Try this instead:

CONCATENATE(
IFS((0 <> [WASHING]), ("Washing - " & [WASHING] & "
")), IFS((0 <> [DAMAGE]), ("Damage - " & [DAMAGE] & "
")), IFS((0 <> [Road Fare]), ("Road - " & [Road Fare] & "
")), IFS((0 <> [Others]), ("Others - " & [Others]))
)
5

Or this:

SUBSTITUTE(
  CONCATENATE(
    LIST(
      IFS((0 <> [WASHING]), ("Washing - " & [WASHING])),
      IFS((0 <> [DAMAGE]), ("Damage - " & [DAMAGE])),
      IFS((0 <> [Road Fare]), ("Road - " & [Road Fare])),
      IFS((0 <> [Others]), ("Others - " & [Others]))
    )
    - LIST("")
  ),
  " , ",
  "
"
)
1 Like
6

It really worked.
Thank my Steve Bro.
I will try to understand this.
Again, Thanks.
It was not a big thing for many but It had been gnawing at me for weeks now.

1 Like