如何将图像添加到报告中的单元格中

在产品开发过程中,我们将一张表分成多个报告,供不同的用户使用。ob欧宝娱乐app手机下载表单包含所有列,是唯一的真相来源,而报告给出每个步骤的快照,只显示与该步骤/用户相关的列。

我的问题:

可以将图像复制/粘贴到工作表的单元格中,也可以在单元格中右击以添加图像。然而,这两个函数都不能在报表中使用,只能在工作表中使用。我知道你可以附加一个图像到行,但此时文档生成器不能从附加到行,并将它们添加到文档生成器创建PDF文件的图像。所以我们现在用细胞中的图像来连接。

在不让单独的步骤用户进入主表并尝试理解所有额外的数据和列的情况下,是否有另一种方法在报告的单元格中添加图像?

我已经提出了一个产品增强的要求,但我认为我应该问ob欧宝娱乐app手机下载社区以及。

谢谢你的时间,

迈克尔

附加Image.png文件


最好的答案

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭
    ✓回答

    @Michael Halvey

    我希望你一切安好!

    不幸的是,据我所知,这现在是不可能的,但这是一个很好的主意!

    请在您有时间的时候提交增强请求

    我希望这能有所帮助!

    注意安全,祝你周末愉快!

    最好的

    她名叫Stara|工作流顾问/ CEO @工作大胆

    我的帖子是否帮助或回答了你的问题或解决了你的问题?请通过以下方式支持社区将其标记为有见地/投票赞成或/和作为可接受的答案.这将使别人更容易找到解决方案或帮助回答!

    Smartsheet专家顾问和合作伙伴

    她名叫Stara|工作流顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时联系我有关Smartsheet的帮助,集成,一般的工作流程建议,或其他完全的东西。

  • 迈克尔Halvey
    迈克尔Halvey ✭✭✭✭✭✭
    ✓回答

    @Andree Stara我发现了一个在报告单元格中添加图像的小方法,我认为我可以分享这个方法。

    如果双击行最左边的键,就可以在垂直弹出框中填充行数据。

    向下滚动到要向其中添加图像的单元格并单击其中。

    如果您从它的位置(桌面/服务器文件夹/云服务)复制图像,然后将其粘贴到单元格。

    在垂直弹出窗口的底部点击保存,它将立即出现在报告的正确单元格中。这只适用于垂直弹出屏幕,而不仅仅是在报告中。

    图片来自Reports.png

    这比进入主表,找到行,右键单击和插入图像>上传文件或复制/粘贴图像从您的桌面到单元格快得多。

    希望有一天我们可以将图像直接复制/粘贴到Report单元格中,但在那之前,这只是一个很好的解决办法。

    祝你度过一个美好的夜晚!

    迈克尔

答案

Hey @SkiPatrolScott<\/a> <\/p>

Yes, you can use an existing summary field in another summary field within the same sheet. You can either click into the formula field of the existing formula to add to new formula, or type out the field name. Summary fields use a # in place of a row indicator. Using your example from above:<\/p>

=new formula =[SS-Result1]#<\/strong>-[SS-Result2]#<\/strong><\/p>

If this doesn't make sense, help me understand where I lost you and I will try to explain it better.<\/p>

Kelly<\/p>"},{"commentID":353136,"body":"

Thanks @Kelly Moore<\/a> , I did have to add a ( around the equation ) but it did work.<\/p>

=sum([summary field1]#-[summary field2]) the correct answer was produced.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-05 14:48:17","updateUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":98381,"type":"question","name":"Smartsheet Form Logo Question","excerpt":"Hello Smartsheet Community, I have a question that is probably obvious that I am overlooking it. I am creating and I am incorporating a logo into the form. I am able to incorporate the logo, but it's small when you open the form. Is there a way to make the logo bigger? Or, elongate the image so it goes across the top of…","categoryID":321,"dateInserted":"2022-12-02T20:32:19+00:00","dateUpdated":null,"dateLastComment":"2022-12-03T18:37:12+00:00","insertUserID":147643,"insertUser":{"userID":147643,"name":"Anthony DAmbrosio","url":"https:\/\/community.smartsheet.com\/profile\/Anthony%20DAmbrosio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:14:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2022-12-06T02:05:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3340106371,"url":"https:\/\/community.smartsheet.com\/discussion\/98381\/smartsheet-form-logo-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98381\/smartsheet-form-logo-question","format":"Rich","lastPost":{"discussionID":98381,"commentID":353078,"name":"Re: Smartsheet Form Logo Question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353078#Comment_353078","dateInserted":"2022-12-03T18:37:12+00:00","insertUserID":112221,"insertUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2022-12-06T02:05:51+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\/868U3BF057NI\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-05T17:14:43+00:00","dateAnswered":"2022-12-03T18:37:12+00:00","acceptedAnswers":[{"commentID":353078,"body":"

Hello @Anthony DAmbrosio<\/a> <\/p>

The following reference states the dimensions for a form logo is 300pix wide x 52pix tall. <\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/2478921-create-a-quality-logo-to-brand-your-smartsheet-items#toc-where-your-logo-appears-and-how-smartsheet-resizes-it\n <\/a>\n<\/div>

You may need to play with your layout, as suggested in the article, to maximize the size of the text.<\/p>

Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-05 17:14:43","updateUser":{"userID":147643,"name":"Anthony DAmbrosio","url":"https:\/\/community.smartsheet.com\/profile\/Anthony%20DAmbrosio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:14:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":98386,"type":"question","name":"How do I get Data Table to recognize dates uploaded by Data Shuttle?","excerpt":"Hi, I'm trying to create a new Data Table using Data Shuttle. I have some columns with date date. It seems that, no matter how I format the dates in the source CSV, Data Table won't recognize them as dates. Data Shuttle doesn't have an option to set the date format when creating a Data Table. I wish it would. I know I can…","categoryID":343,"dateInserted":"2022-12-02T23:54:10+00:00","dateUpdated":null,"dateLastComment":"2022-12-03T00:27:58+00:00","insertUserID":140451,"insertUser":{"userID":140451,"name":"Brian_Richardson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brian_Richardson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3gsODavHSggzZ-xp1nf0UGuLXkegzF2uAZRanwGQ=s96-c","dateLastActive":"2022-12-05T15:47:24+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"updateUserID":null,"lastUserID":140451,"lastUser":{"userID":140451,"name":"Brian_Richardson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brian_Richardson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3gsODavHSggzZ-xp1nf0UGuLXkegzF2uAZRanwGQ=s96-c","dateLastActive":"2022-12-05T15:47:24+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":null,"hot":3340053128,"url":"https:\/\/community.smartsheet.com\/discussion\/98386\/how-do-i-get-data-table-to-recognize-dates-uploaded-by-data-shuttle","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98386\/how-do-i-get-data-table-to-recognize-dates-uploaded-by-data-shuttle","format":"Rich","tagIDs":[426,474],"lastPost":{"discussionID":98386,"commentID":353068,"name":"Re: How do I get Data Table to recognize dates uploaded by Data Shuttle?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353068#Comment_353068","dateInserted":"2022-12-03T00:27:58+00:00","insertUserID":140451,"insertUser":{"userID":140451,"name":"Brian_Richardson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brian_Richardson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3gsODavHSggzZ-xp1nf0UGuLXkegzF2uAZRanwGQ=s96-c","dateLastActive":"2022-12-05T15:47:24+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-03T00:28:02+00:00","dateAnswered":"2022-12-03T00:27:58+00:00","acceptedAnswers":[{"commentID":353068,"body":"

Never mind, I found the solution. If you import dates in the format YYYY-MM-DDT00:00:00Z then Data Table will recognize that format as a date. I also tested syncing to a Sheet and the sheet recognizes that as a date and displays it correctly based on regional setting (mine being MM\/DD\/YY)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-03 00:28:02","updateUser":{"userID":140451,"name":"Brian_Richardson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brian_Richardson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3gsODavHSggzZ-xp1nf0UGuLXkegzF2uAZRanwGQ=s96-c","dateLastActive":"2022-12-05T15:47:24+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"}}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":426,"urlcode":"DataTable","name":"DataTable"},{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">