How do I use a carriage return in a drop-down...

(Dave Wagner) #1

How do I use a carriage return in a drop-down menu?

I have a form for cycle counting our inventory.

The drop-down contains a CONCATENATE of the item number and the item description.

I have a CHAR(10) in between the two texts in the formula, but the drop down in Appsheet ignores it.

=IF(A2<>"",CONCATENATE(A2,CHAR(10),B2),"")

I need it displayed in the drop-down as such: R030S-CL5B8 RCP,30",SF-GK,CL5,B,8FT,TIED

but on Appsheet it ends up being displayed like this:

(Aleksi Alkio) #2

Normally you can make a carriage return with the format… CONCATENATE("

") but it doesn’t work with the dropdown.