Line Break &" "& to be conditional

AppSheet AppSheet Q&A
1

CONCATENATE(
if(isnotblank([A]),Concatenate(Others," - “,[A]),”“)&”
“& if(isnotblank([B]),Concatenate(Washing,”- “,[B]),”“)&”
“& if(isnotblank([C]),Concatenate(Damage,” - “,[C]),”“)&”
“& if(isnotblank([D]),Concatenate(Road,” - “,[D]),”"))

What I need to do is
&"
"&

to also be conditional. Thanks in advance.

2

This:

&IFS(condition-expression, "
")&

See also: IFS()

3 Likes
3

Steve Bro,
Can you elaborate more?
I have no experiences in this and trying to self learn.
So, please bear with me.

4

&IFS(
isnotblank([WASHING]),Concatenate(Washing," - “,[WASHING]),
isnotblank([DAMAGE]),Concatenate(Damage,” - ",[DAMAGE])
)&

Error - Expressin was unable to be parsed.

5

if(isnotblank([A]),Concatenate(Others," - ",[A]),&ifs(condition,value)&
also return the same error Expression was unable to be parsed.

6

My Problem
My Problem781×1146 57.1 KB

My used 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]),”")
)