Yay! Text formatting in Smartsheet forms
Smartsheet forms now have the ability to format text in the form title, form description, and field help text. Check it out and let us know what you think.
- Style (Bold, Italic, Underline)
- Text color & highlight color
- Bullets & numbering
- Justification (left, center, right, indent)
- Hyperlink
Comments
-
Andrée Starå ✭✭✭✭✭✭Yay indeed!
A fantastic addition to forms.
Thanks,@Caroline Sheldonand the rest of the Smartsheet Team.
Be safe and have a fantastic week!
Best,
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Aaron Smith ✭✭✭
This is great to hear- thanks Smartsheet Team!!!
-
Joe Goetschel ✭✭✭✭✭✭ -
Jay R ✭
Good news....When are we getting bullets into a cell in a sheet? :-) this would help a lot with formatting text.....
-
c.ball ✭Has anyone noticed that since this change all of their existing forms have messed up formatting in the text section? All of our links are no longer clickable, and any formatting we had set is now gone. Anyone else or only me?
-
DWise ✭
Thanks Forms Team.
Would prefer the title block to default to justified centered though!
-
Paul Newcome ✭✭✭✭✭✭One thing I have found that I personally don't like is that the bullets/numbering is also part of the actual title field. If I have a solution that requires forms to be filled out in a specific order, I like to label them
'1. First Form Name
“2。第二个表单名称
so on and so forth.
The problem is that naming this like this (without the apostrophe as it looks a little tacky in my opinion) treats it as numbering/bullets. It indents the title a little bit and the number itself does not actually show up in the title field when you open the. I wouldn't mind the slight indentation if the number would stay. It also reverts back to 1 on every form since it is being considered as the first "bullet point".
As long as you don't use the period it will stay as the text string and not be considered a bullet point, but I like the look of having the period in there.
Long story short... I guess you could say that I would prefer if we could make the numbering/bullets optional and not automatic based on what is typed in.
thinkspi.com
-
Nick Burrus ✭✭✭✭✭✭Huge win.
Dr. St Nicholas Burrus DHA, PMP
I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.
-
曼迪海豹 ✭
Love this new feature but formatting for the numbered list in the description edit field is different than it is in the form. Is there a way to make the form look like description edit field?
-
Sarah Donnelly ✭✭✭✭✭@Caroline Sheldonthis is great news! My communications director will be so happy. Thank you Smartsheet Team!
-
I was elated when I saw this - game changer for sure!
-
Anja Smeets ✭✭✭Awesome!!!!
-
Zachw ✭✭✭
Yes I saw something like this happen to all my existing forms recently, but not sure if it is tied to the new feature or not. I had to fix all the formatting and it hasn't come up again so far.
-
Cleversheet ✭✭✭✭✭✭This is awesome.
i appreciate the caveats raised by the contributors in this thread; it’ll help me be alert to some of the limitations of the feature so I can design around them.
Thanks, Smartsheet team!
-
Alison Clancy Employee Admin
Categories
@Shawn_K2<\/a> UGH I make a mistake. I copied your formula without looking at it close enough 😜<\/span><\/p> try =COUNTIFS({CPR Request Type}, HAS(@cell, \"VAVE\"))<\/p>"},{"commentID":382446,"body":" @Shawn_K2<\/a> <\/p> =COUNTIFS({CPR Request Type}, HAS(@cell, \"VAVE\"), {CPR Brand}, HAS(@cell, \"ING\"))<\/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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106847,"type":"question","name":"Missing drop-down options in my filter selections. Where did they go?","excerpt":"I have been creating filters and for some reason a couple of my drop-down options are not showing up as filter selections, even though they are correctly showing up as drop-down options in the sheet. To illustrate, here are the drop-down options I have for a column in my sheet, which are working correctly: but when I try…","categoryID":321,"dateInserted":"2023-06-23T18:16:31+00:00","dateUpdated":null,"dateLastComment":"2023-06-26T16:54:06+00:00","insertUserID":162342,"insertUser":{"userID":162342,"name":"mgreenwalt","title":"coordinator","url":"https:\/\/community.smartsheet.com\/profile\/mgreenwalt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-26T17:20:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-27T06:21:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":65,"score":null,"hot":3375348637,"url":"https:\/\/community.smartsheet.com\/discussion\/106847\/missing-drop-down-options-in-my-filter-selections-where-did-they-go","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106847\/missing-drop-down-options-in-my-filter-selections-where-did-they-go","format":"Rich","lastPost":{"discussionID":106847,"commentID":382360,"name":"Re: Missing drop-down options in my filter selections. Where did they go?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382360#Comment_382360","dateInserted":"2023-06-26T16:54:06+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-27T06:21:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2JV6OYUHWHZT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-26T16:04:32+00:00","dateAnswered":"2023-06-26T15:48:56+00:00","acceptedAnswers":[{"commentID":382315,"body":" Thanks @topazfae<\/a> for your time and efforts and I'm happy to announce that @Genevieve P.<\/a> solved this challenge 😃<\/span> - <\/p> \"I can see that your two selections have 135 and 142 characters each. When I cut the character count under 100<\/strong>, they appear as options to filter by.\"<\/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=341&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":5410,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
<\/p>
