添加Ons和集成

询问有关控制中心、动态视图、数据网、轴心应用程序、日历应用程序、工作应用程序或资源管理的问题。讨论如何使用Bridge、Data Shuttle、Jira连接器和Salesforce连接器等集成将Smartsheet连接到其他系统。

讨论表

类别

受欢迎的标签

@Khari Shiver<\/a> <\/p>
  1. In the mapping screen, drag the filename onto the Output document name field. <\/li><\/ol>


    <\/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":370,"urlcode":"document-builder","name":"Document Builder"}]},{"discussionID":101784,"type":"question","name":"Help on Index(collect) to drag the values down","excerpt":"I have a source sheet which receives value from a DB and this sheet keeps updating on daily basis. I have added 2 new columns in the source sheet as \"CreatedDate\" and \"Status\". The \"Status\" value had a formula o update the value as 1 if the record is latest and 0 if the record is old. So whenever there new data is added to…","categoryID":321,"dateInserted":"2023-02-27T12:35:48+00:00","dateUpdated":"2023-02-27T15:26:53+00:00","dateLastComment":"2023-02-28T05:46:00+00:00","insertUserID":158767,"insertUser":{"userID":158767,"name":"VijiNair","url":"https:\/\/community.smartsheet.com\/profile\/VijiNair","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-28T06:52:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":158767,"lastUserID":129958,"lastUser":{"userID":129958,"name":"Lucas Rayala","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!TEYKqbaL30P","dateLastActive":"2023-02-28T06:55:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":42,"score":null,"hot":3355066908,"url":"https:\/\/community.smartsheet.com\/discussion\/101784\/help-on-index-collect-to-drag-the-values-down","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101784\/help-on-index-collect-to-drag-the-values-down","format":"Rich","lastPost":{"discussionID":101784,"commentID":364650,"name":"Re: Help on Index(collect) to drag the values down","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/364650#Comment_364650","dateInserted":"2023-02-28T05:46:00+00:00","insertUserID":129958,"insertUser":{"userID":129958,"name":"Lucas Rayala","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!TEYKqbaL30P","dateLastActive":"2023-02-28T06:55:52+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-28T05:24:41+00:00","dateAnswered":"2023-02-28T00:48:01+00:00","acceptedAnswers":[{"commentID":364638,"body":"

    Hi @VijiNair<\/a>, that's a good start -- the values don't copy down like an Excel sheet. The \"1\" in this case is a row reference for the returned Index, which I think you understand. Easiest thing to do to get this to work:<\/p>

    Create a column, NumberedRows, and number the cells sequentially 1,2,3,4, etcs. Add as many values as you think you might need.<\/p>

    In the column you are currently trying to add the formula, update your formula to say:<\/p>

    =IFERROR(INDEX(COLLECT(<\/strong>{Data 1 Name}, {Data 1 Range 2}, \"YES\")<\/strong>, NumberedRows@row),\"//www.santa-greenland.com/community/categories/apps-and-integrations/\")<\/p>

    When you have this working, right click the cell and make this a column formula by selecting \"Column formula\" (you have to be a sheet Admin or Owner to do this, otherwise just copy and paste it).<\/p>

    The \"IFERROR\" is to keep the formula from returning an error if the you have more numbered rows in \"Numbered Rows\" than you will be returning from your source sheet.<\/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":101782,"type":"question","name":"Is there a possibility to connect different cells between two sheets?","excerpt":"I have two different sheets. One has a collumn with \"areas\" as texts and a collumn with \"teams\" which are again text. While working I put manually which team works for each area. But in a new sheet I need to put the area name and take the team name, as a result, automatically. Does anyone has an idea on this?","categoryID":321,"dateInserted":"2023-02-27T11:38:17+00:00","dateUpdated":"2023-02-27T11:42:56+00:00","dateLastComment":"2023-02-27T12:15:42+00:00","insertUserID":158770,"insertUser":{"userID":158770,"name":"D.Koutroulis","url":"https:\/\/community.smartsheet.com\/profile\/D.Koutroulis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-27T12:19:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":158770,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","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-02-28T07:19:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":35,"score":null,"hot":3355000439,"url":"https:\/\/community.smartsheet.com\/discussion\/101782\/is-there-a-possibility-to-connect-different-cells-between-two-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101782\/is-there-a-possibility-to-connect-different-cells-between-two-sheets","format":"Rich","lastPost":{"discussionID":101782,"commentID":364484,"name":"Re: Is there a possibility to connect different cells between two sheets?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/364484#Comment_364484","dateInserted":"2023-02-27T12:15:42+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","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-02-28T07:19:07+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-27T12:13:13+00:00","dateAnswered":"2023-02-27T11:54:57+00:00","acceptedAnswers":[{"commentID":364482,"body":"

    Hi @D.Koutroulis<\/a> <\/p>

    This is absolutely doable with a cross sheet VLOOKUP. Suppose you have your first sheet with data like this:<\/p>

    \n
    \n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

    In a second sheet, you can have the Area and Team columns again, with the following formula in the Team column:<\/p>

    =VLOOKUP(Area@row, {Areas & Teams Range 1}, 2, false)<\/p>

    To do the cross sheet bit - in the { } brackets, click this button when entering the formula:<\/p>

    \n
    \n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

    Then find the first sheet and highlight the columns you're after (in this case it is simple as there are only 2):<\/p>

    \n
    \n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

    Then click the Insert reference button you can see in the bottom right of the open window.<\/p>

    You can then use the second sheet to have the team looked up from the area:<\/p>

    \n
    \n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

    The blue arrows in the \"Team lookup\" column indicate the data is coming from elsewhere, and the grey arrows on the other sheet show the data is going out to another sheet.<\/p>

    Hope this is of some assistance; if you've any questions etc. then just ask! 😊<\/span><\/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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">