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:
Normally you can make a carriage return with the formatโฆ CONCATENATE("
") but it doesnโt work with the dropdown.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |