Text Wrapping is not working.

katjie.carpenter79866
katjie.carpenter79866 ✭✭
edited 12/09/19 inSmartsheet Basics

Hi,

I've created a new sheet and a form, I've applied text wrap to the columns that might need it and I've tested certain cells, inputting more text than the cell than would be visible. I've clicked an unclicked the text wrap button on the menu... nothing is happening. I've saved and refreshed the sheet...still no text wrap.

Can you help? I've also tried adding in Ctrl+enter to add a new line of text. Does nothing.

Thanks for the help!

Tags:
· Share on Facebook Share on Twitter

Comments

Categories

@Jillian M<\/a> an IF statement will do what you need.<\/p>

=if([Column Name]@row=\"Value\",1,0)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107883,"type":"question","name":"Moving closed \"tickets\" to a second sheet","excerpt":"I have a sheet where we log our support as it comes in. I have a \"completed\" check box to check once it is finished. It also has a date created field. I setup a second copy of the sheet. On the first sheet I added automation to move any row that is \"completed\" and over 3 days old to the second sheet. This works well.…","snippet":"I have a sheet where we log our support as it comes in. I have a \"completed\" check box to check once it is finished. It also has a date created field. I setup a second copy of the…","categoryID":321,"dateInserted":"2023-07-20T20:03:02+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T20:49:17+00:00","insertUserID":163730,"insertUser":{"userID":163730,"name":"TheoR74","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/TheoR74","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T18:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163730,"lastUser":{"userID":163730,"name":"TheoR74","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/TheoR74","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T18:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":45,"score":null,"hot":3379770739,"url":"https:\/\/community.smartsheet.com\/discussion\/107883\/moving-closed-tickets-to-a-second-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107883\/moving-closed-tickets-to-a-second-sheet","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":107883,"commentID":386291,"name":"Re: Moving closed \"tickets\" to a second sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386291#Comment_386291","dateInserted":"2023-07-20T20:49:17+00:00","insertUserID":163730,"insertUser":{"userID":163730,"name":"TheoR74","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/TheoR74","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T18:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T20:50:00+00:00","dateAnswered":"2023-07-20T20:14:12+00:00","acceptedAnswers":[{"commentID":386274,"body":"

@TheoR74<\/a>,<\/p>

As long as your destination sheet doesn't have the numbering column setup as an Auto Number, you should be fine. In your destination sheet, keep the numbering column as a \"Text\/Number\" column instead.<\/p>

BRgds,<\/p>

-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":107872,"type":"question","name":"Using Sum function on 2 referring pages","excerpt":"I am trying to sum to different cells on 2 different Smart Sheets and I I keep on getting a #UNPARSEABLE error. It works fine when it references only 1 sheet but I need to sum probably about 20+ sheets when I am done. Just testing with 2 right now. Any help is appreciated =SUM({AAA Pet Services - Sign Ups Range 1}{AAA Pet…","snippet":"I am trying to sum to different cells on 2 different Smart Sheets and I I keep on getting a #UNPARSEABLE error. It works fine when it references only 1 sheet but I need to sum…","categoryID":321,"dateInserted":"2023-07-20T17:37:32+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T18:10:31+00:00","insertUserID":163722,"insertUser":{"userID":163722,"name":"John C0","url":"https:\/\/community.smartsheet.com\/profile\/John%20C0","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:10:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163722,"lastUser":{"userID":163722,"name":"John C0","url":"https:\/\/community.smartsheet.com\/profile\/John%20C0","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:10:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":38,"score":null,"hot":3379752483,"url":"https:\/\/community.smartsheet.com\/discussion\/107872\/using-sum-function-on-2-referring-pages","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107872\/using-sum-function-on-2-referring-pages","format":"Rich","lastPost":{"discussionID":107872,"commentID":386231,"name":"Re: Using Sum function on 2 referring pages","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386231#Comment_386231","dateInserted":"2023-07-20T18:10:31+00:00","insertUserID":163722,"insertUser":{"userID":163722,"name":"John C0","url":"https:\/\/community.smartsheet.com\/profile\/John%20C0","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T18:10:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T18:10:07+00:00","dateAnswered":"2023-07-20T17:56:18+00:00","acceptedAnswers":[{"commentID":386226,"body":"

=SUM({AAA Pet Services - Sign Ups Range 1}, {AAA Pet Services - Sign Ups Option 2 Range 1})<\/p>

A comma is needed between each range to sum.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4868,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • True/False formula?

    I'm trying to figure out a formula to note a "1" in the cell if the information in the cell next to it is a certain value, any other value needs to show a "0". Is this a "true/false" formula? I figured this out: =IF([Question 1]@row = "2. I should avoid using the electronic device during the initial connection; however,…

  • Moving closed "tickets" to a second sheet

    I have a sheet where we log our support as it comes in. I have a "completed" check box to check once it is finished. It also has a date created field. I setup a second copy of the sheet. On the first sheet I added automation to move any row that is "completed" and over 3 days old to the second sheet. This works well.…

  • Using Sum function on 2 referring pages

    I am trying to sum to different cells on 2 different Smart Sheets and I I keep on getting a #UNPARSEABLE error. It works fine when it references only 1 sheet but I need to sum probably about 20+ sheets when I am done. Just testing with 2 right now. Any help is appreciated =SUM({AAA Pet Services - Sign Ups Range 1}{AAA Pet…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video