I would love to see rich text formatting be available in cells on a sheet. We have several reports where we rely on certain words in a cell to be a different color than the other words in a cell (quickly showing variable options or redlining changed content if only a word or two has been altered). Currently, we are only able to house these items in Excel. It would be a game changer to be able to move this data into Smartsheet.
Allow font change of part of text in a cell.
Exactly Girish!
My team adds full descriptions within a single cell, the ability to create hierarchy with text within a specific cell is a necessity.
Yes, Anders. Easily bullet/indent. Bold only certain text. Color only certain text. Any way to format the text within the cell without formatting the entire contents of the cell in the same format.
Upvote this. Read in another post a suggestion that there be a column type for rich text. Would be very useful for note fields that roll up in reports.
Could you not use conditional formatting? Could you also not use the highlight feature to show cells that have had changes?
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Not for redlined items. We need to mark variable options in a certain color and mark changes in another color to that changes are quickly identified. If there are multiple paragraphs of text, and we edit 2 words, we need to redline those two words so that approvers know exactly what was changed quickly just by looking at the content of the cell. Plus some of our content has items that are required to be bolded, but not the entire content, only certain words. This cannot be done currently in Smartsheet.
Grateful for this post. So frustrating not being able to format only required text rather than the whole cell.
Some formatting options:
Adding onto Heather's excellent list above...
• tiered bullet points within a cell (different bullet style for different levels of text indent). Use case: We use bullets all the time in "executive summary"/comments cells that roll up to a leadership dashboard. They break up the text and make it easier to read at a glance. Tiered bullets would be especially good for documentation housed in a Smartsheet, something I am working towards to keep our project toolkit centralized.
• numbering within a cell (creating numbered lists of text). Use case: Logging several steps that must be completed to resolve a risk on a risk log, and other numerous similar cases.
Thanks for the suggestion! This is something we are actively looking into. We are trying to understand the details around what formatting options are most important and why. Please continue to reply with details and associated scenarios.
We have a Weekly Status Tracker Sheet for "Accomplishments, In progress, and Up Next" and having formatting capabilities would provide increased readability as this sheet surfaces on our project dashboards. This sheet is just one example.
My team has requested rich text formatting in cells as well as a character limit increase. They use cells to paste in full email messages and meeting minutes rather than attach documents. Some of this info is emailed weekly to project stakeholders as an automatically generated PDF from a report. They often reach the character limit and desire the ability to visually organize the content they paste in via standard formatting options.
Hello,
I've addressed this request several times in the past, but it wasn't addressed yet.
My request is simple - To enable changing the format of part of a field. For instance, to change the color of some of the text in a particular field. That's it.
Thanks,
Dror, Radware
It would greatly expand the applicability of Smartsheets to be able to rely on it as a content repository also - where italics, bold, bullets etc. are preserved and can be added. It is helpful to be able to call out specific information to stakeholders. Also to send content for review and approval directly from the rows as part of the Smartsheet workflow tools without having to rely on attachments, separate email communications, etc. Because text formatting is not preserved, it creates added work to have to export and manually convert formatting. Can't just paste the approved text into Smartsheet and export it in the same format you want; have to manually convert it every time.