登录提交新的想法和投票
开始

单元格中的富文本格式

我希望看到富文本格式可以在工作表的单元格中使用。我们有几个报告,其中我们依赖于单元格中的某些单词与单元格中的其他单词的颜色不同(如果只有一两个单词被更改,则快速显示变量选项或标记更改的内容)。目前,我们只能在Excel中存放这些项目。如果能够将这些数据转移到Smartsheet中,将会改变游戏规则。

63
63票

在路线图·最后一次更新

谢谢你的建议!我们正在积极调查此事。我们正试图了解哪些格式选项是最重要的,以及为什么。请继续在这篇文章中添加您的场景的评论。

«1

评论

  • Heather_Verde
    Heather_Verde ✭✭✭✭✭
  • 我的团队在单个单元格中添加完整的描述,因此必须能够在特定单元格中使用文本创建层次结构。

  • Upvote这个。阅读另一个帖子的建议,有一个列类型的富文本。对于在报告中卷起的注释字段非常有用。

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭

    你能不使用条件格式吗?您是否也可以不使用突出显示功能来显示已发生更改的单元格?

    乔纳森·桑德斯,CSM

    “改变总是可怕的,因为它是未知的,但面对未知会让我们变得更强大。”

  • Heather_Verde
    Heather_Verde ✭✭✭✭✭

    红线项不适用。我们需要以某种颜色标记变量选项,并以另一种颜色标记更改,以便快速识别更改。如果有多个文本段落,并且我们编辑了2个单词,我们需要对这两个单词进行重新标记,以便审批者仅仅通过查看单元格的内容就能准确地知道哪些内容被快速更改了。另外,我们的一些内容有需要加粗的项目,但不是整个内容,只有某些单词。目前在Smartsheet中无法完成此操作。

  • 感谢这篇文章。所以令人沮丧的是,不能只格式化所需的文本,而不是整个单元格。

  • 谢谢你的建议!我们正在积极调查此事。我们正试图了解哪些格式选项是最重要的,以及为什么。请继续回复详细信息和相关场景。或者您可以安排时间直接在这里与我们交谈:https://go.oncehub.com/OlenRonning

  • 状态跟踪器示例:png

    我们有一个每周状态跟踪表,用于“完成,进行中,下一步”,并且具有格式化功能将增加该表在我们的项目仪表板上的可读性。这张纸只是一个例子。

  • 我的团队要求在单元格中使用富文本格式以及增加字符限制。他们使用单元格粘贴完整的电子邮件信息和会议纪要,而不是附加文档。其中一些信息每周通过电子邮件从报告中自动生成PDF发送给项目干系人。他们经常达到字符限制,并希望能够通过标准格式选项直观地组织他们粘贴的内容。

  • 你好,

    我过去已经提出过几次这个要求,但它还没有得到解决。

    我的请求很简单-启用更改字段的一部分的格式。例如,更改特定字段中某些文本的颜色。就是这样。

    谢谢,

    Dror, Radware

  • 这将极大地扩展Smartsheets的适用性,使其能够依赖于它作为一个内容存储库——斜体、粗体、项目符号等都被保留并可以添加。能够向利益相关者提出具体信息是很有帮助的。作为Smartsheet工作流工具的一部分,还可以直接从行发送内容以供审查和批准,而不必依赖附件,单独的电子邮件通信等。由于没有保留文本格式,因此必须导出和手动转换格式,从而增加了工作量。不能只是将批准的文本粘贴到Smartsheet并以您想要的格式导出;每次都要手动转换。

2023-05-13T20:35:39.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106339,"type":"idea","name":"Single Row Timeline","excerpt":"Would love to see a single row timeline that provides a condensed view for senior leadership. This is one capability that is asked for a lot, but currently is not available.","categoryID":349,"dateInserted":"2023-06-12T20:56:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T18:17:17+00:00","insertUserID":107206,"insertUser":{"userID":107206,"name":"Pam Ferguson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pam%20Ferguson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!wc1AMAYHDEQ!woNBt-bwO3Q!6Y9I4ypKEQB","dateLastActive":"2023-06-13T19:25:39+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"updateUserID":null,"lastUserID":162333,"lastUser":{"userID":162333,"name":"joepickett","url":"https:\/\/community.smartsheet.com\/profile\/joepickett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-13T18:18:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":24,"score":2,"hot":3373284817,"url":"https:\/\/community.smartsheet.com\/discussion\/106339\/single-row-timeline","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106339\/single-row-timeline","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106339,"commentID":380362,"name":"Re: Single Row Timeline","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380362#Comment_380362","dateInserted":"2023-06-13T18:17:17+00:00","insertUserID":162333,"insertUser":{"userID":162333,"name":"joepickett","url":"https:\/\/community.smartsheet.com\/profile\/joepickett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-13T18:18:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SUNNQ4CW55GQ\/timeline-visual-sample-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"timeline_visual_sample.PNG"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106271,"type":"idea","name":"Print Dynamic View","excerpt":"Print or export the Dynamic View in order to distribute it to students and faculty.","categoryID":349,"dateInserted":"2023-06-09T14:39:25+00:00","dateUpdated":"2023-06-09T14:48:13+00:00","dateLastComment":"2023-06-12T21:23:49+00:00","insertUserID":158793,"insertUser":{"userID":158793,"name":"megarceau","url":"https:\/\/community.smartsheet.com\/profile\/megarceau","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:37:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":160129,"lastUser":{"userID":160129,"name":"vdemattei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/vdemattei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T21:41:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":2,"hot":3372927794,"url":"https:\/\/community.smartsheet.com\/discussion\/106271\/print-dynamic-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106271\/print-dynamic-view","format":"Rich","tagIDs":[363,443,445],"lastPost":{"discussionID":106271,"commentID":380212,"name":"Re: Print Dynamic View","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380212#Comment_380212","dateInserted":"2023-06-12T21:23:49+00:00","insertUserID":160129,"insertUser":{"userID":160129,"name":"vdemattei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/vdemattei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T21:41:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}]},{"discussionID":106267,"type":"idea","name":"Have Smartsheet auto include a generated PDF in the notification email","excerpt":"Hello! Is there way to have Smartsheet auto include a generated PDF in the notification email it sends out once a form is filled out and submitted? I'm still relatively new to Smartsheet and I currently have the automation set up to generate a document with each form submission and send an email to a specified email…","categoryID":349,"dateInserted":"2023-06-09T14:04:36+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T21:02:34+00:00","insertUserID":155580,"insertUser":{"userID":155580,"name":"Emilie","url":"https:\/\/community.smartsheet.com\/profile\/Emilie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-13T18:56:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":160129,"lastUser":{"userID":160129,"name":"vdemattei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/vdemattei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T21:41:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":49,"score":2,"hot":3372926830,"url":"https:\/\/community.smartsheet.com\/discussion\/106267\/have-smartsheet-auto-include-a-generated-pdf-in-the-notification-email","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106267\/have-smartsheet-auto-include-a-generated-pdf-in-the-notification-email","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106267,"commentID":380203,"name":"Re: Have Smartsheet auto include a generated PDF in the notification email","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380203#Comment_380203","dateInserted":"2023-06-12T21:02:34+00:00","insertUserID":160129,"insertUser":{"userID":160129,"name":"vdemattei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/vdemattei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T21:41:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-13T20%3A35%3A39%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":155,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">