Row height problem
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
Answers
-
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.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
Thanks for taking the time to respond!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!