Conditional Line Break, is it possible?

AppSheet AppSheet Q&A
1

Column A - Text # Column B - Text # Column C - Number # Column D - Long Text

If Column A isnotblank Concatenate([A] ,“Text”) then add a line break
If Column A isblank just “” and so on till Column C.

And this expression will be formula of Column D.

Any thoughts?

2

This?

IFS(condition, "
")
1 Like
3

Whatever works. lol
IF or IFs

If( isnotblank[ColumnA]) ,Concatenate([A] ,“Text”) then add a line break, do nothing**)**

4

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]),”") )
This is the definitive line break. So if any column is blank it add the blank line.
That’s why I need it to be conditional.