Row height problem

Kidd

Hello!

I have looked through a lot of searches, and cannot seem to see a resolution to this problem. Sorry in advance if I'm missing something easy!

I have a sheet that allows an input word in the yellow box to search another sheet. Looks like this before entry:

As soon as you enter a word, and hit enter, it uses a formula to go out and search the other sheet and give me the following list of results using JOIN / COLLECT combination with a CHAR(10) delimiter to make a list in the DS Results cell.

Formula: =JOIN(COLLECT({DS Reference Links}, {DS Reference Helper}, CONTAINS([Search Column]@row, @cell)), CHAR(10))

Result:

It gives me exactly what I want in the DS Results, but I cannot see the bottom two entries, until I hit the cell and turn wrap on and off, or save and refresh the file - then it looks like this:

That is correct, regarding results from the formula and how I want it to look. Any ideas on getting it to auto adjust the height correctly? Any way to turn auto wrap on and off in a formula, or get the screen to refresh, or anything like that? The number of DS results change depending on the input and how many results it finds, so it's never consistent.

Thanks for any help you might have!

A. Kidd

kowal

Hi,

I do not think there is a solution to that but you just found a small glitch in the system.

I could see this problem also in Reports where not entire cell is visible and you need to refresh the website.

I would open a ticket with support or put it into product idea part of this community.

Kidd

Thanks for taking the time to respond!