是否有可能在两个智能表之间自动创建链接?

imtonydillard＂class=
imtonydillard ✭
在内容基本知识

对于上面的问题，请考虑一个项目需要2个链接的智能表的场景。现在考虑这样一个场景:50多个项目每个都需要2个链接的smartsheet，一个新项目每周添加到查询中2到3次。

是否可能有两个相互链接的“主”智能表，可以复制并保存到下一个新项目，而不丢失已经创建的链接?如果答案是否定的，是否有可能自动创建两个智能表之间的链接?

标签:

最佳答案

  • 吉纳维芙P。＂class=
    吉纳维芙P。 员工管理
    ✓回答

    嗨@imtonydillard

    如果已经有两个表作为模板链接，那么可以将这两个表都放在一个Folder中。

    然后，当你有一个新项目时，你可以这样做复制文件夹“另存为新”，并选择该选项以保持新表之间的链接:

    屏幕截图21010-14 14:19.38 PM.png＂height=

    让我知道这是否对你有用!

    欢呼,

    吉纳维芙

答案

  • 吉纳维芙P。＂class=
    吉纳维芙P。 员工管理
    ✓回答

    嗨@imtonydillard

    如果已经有两个表作为模板链接，那么可以将这两个表都放在一个Folder中。

    然后，当你有一个新项目时，你可以这样做复制文件夹“另存为新”，并选择该选项以保持新表之间的链接:

    屏幕截图21010-14 14:19.38 PM.png＂height=

    让我知道这是否对你有用!

    欢呼,

    吉纳维芙

  • imtonydillard＂class=
    imtonydillard ✭

    是的,它工作。你太棒了!

  • 吉纳维芙P。＂class=
    吉纳维芙P。 员工管理

    很高兴能帮上忙!

  • Freymish＂class=
    Freymish ✭
    编辑03/14/22

    我有相同的基本场景，除了我想能够添加另一个表作为源，并能够“初始化”一行作为链接到新表。

    如果我用不同的方式做这个，我会调用columnn1 SheetName，然后使链接语句像一个公式:

    ”链接的(电子邮件保护)＂

    有办法做到这一点吗?可能是另一个话题

  • 吉纳维芙P。＂class=
    吉纳维芙P。 员工管理

    嗨@Freymish

    没有一种方法可以通过单元格中的工作表名称来识别工作表，并让公式自动知道要链接到你的工作表;您将需要通过在交叉表引用中选择此范围来创建对该工作表的引用。看到的:Cross-sheet公式

    欢呼,

    吉纳维芙

  • 丹Heizyk＂class=
    丹Heizyk ✭

    与前面的评论类似，我试图为每个项目使用一个模板，并将几个单元格(每个项目的关键日期)卷成一个包含所有项目的母表。我可以有主自动拉从新的表创建不进入和更新表引用?

    或者是否需要对报告进行查找以将信息填充到工作表中?

  • 吉纳维芙P。＂class=
    吉纳维芙P。 员工管理

    嗨@Dan Heizyk

    公式没有办法在创建新表单时自动检测;您将需要手动创建新的交叉表引用。

    报表可以自动包含新的工作表，但只有当您选择整个工作区作为报表的源时(参见:为报表生成器选择源表）

    请通过以下方式让产品团队知道您ob欧宝娱乐app手机下载的功能请求在这儿填这张表。

    谢谢!

    吉纳维芙

类别

Hi @rtrosper<\/a> <\/p>

I hope you're well and safe!<\/p>

Unfortunately, you can't. You'll have to do it one by one, either moving them around in the Workbook or splitting them into different sheets.<\/p>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-21 22:33:19","updateUser":{"userID":152663,"name":"rtrosper","url":"https:\/\/community.smartsheet.com\/profile\/rtrosper","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HhFqH5JDl3s!XWcoX85eCjs!dlPh9heeTbQ","dateLastActive":"2022-09-21T22:32:39+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":[{"tagID":278,"urlcode":"Importing and Exporting","name":"Importing and Exporting"}]},{"discussionID":95655,"type":"question","name":"Form or Report to pull rows that need to be updated","excerpt":"I have a SmartSheet that lists all our Company Contracts, the Contract Owner, Contract Start Date, Contract End Date, etc. I am missing some data and would like the Contract Owner to go to a form and enter their name. They would then be presented with a list of all contracts they are the owner of and be able to update…","categoryID":321,"dateInserted":"2022-09-21T15:14:24+00:00","dateUpdated":null,"dateLastComment":"2022-09-21T19:10:59+00:00","insertUserID":148808,"insertUser":{"userID":148808,"name":"Murph","url":"https:\/\/community.smartsheet.com\/profile\/Murph","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AsDWX88etRY!mSlW3icVs7o!j2xT-scxqYl","dateLastActive":"2022-09-21T19:11:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-21T22:43:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":18,"score":null,"hot":3327563723,"url":"https:\/\/community.smartsheet.com\/discussion\/95655\/form-or-report-to-pull-rows-that-need-to-be-updated","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95655\/form-or-report-to-pull-rows-that-need-to-be-updated","format":"Rich","lastPost":{"discussionID":95655,"commentID":344304,"name":"Re: Form or Report to pull rows that need to be updated","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344304#Comment_344304","dateInserted":"2022-09-21T19:10:59+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\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-21T22:43:03+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":"2022-09-21T19:12:20+00:00","dateAnswered":"2022-09-21T19:10:59+00:00","acceptedAnswers":[{"commentID":344304,"body":"

@Murph<\/a> <\/p>

They don't need access to Smartsheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-21 19:12:20","updateUser":{"userID":148808,"name":"Murph","url":"https:\/\/community.smartsheet.com\/profile\/Murph","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AsDWX88etRY!mSlW3icVs7o!j2xT-scxqYl","dateLastActive":"2022-09-21T19:11:42+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":95661,"type":"question","name":"sheet count?","excerpt":"Is there a way to get a total of the number of sheets currently in an account?","categoryID":321,"dateInserted":"2022-09-21T15:40:16+00:00","dateUpdated":null,"dateLastComment":"2022-09-21T15:47:09+00:00","insertUserID":152598,"insertUser":{"userID":152598,"name":"Ray of Hope","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20of%20Hope","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucpYTh27kmYr-r81E4OkPmSJZFfQThpkGun7LJSz=s96-c","dateLastActive":"2022-09-21T15:50:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-21T22:43:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":15,"score":null,"hot":3327550645,"url":"https:\/\/community.smartsheet.com\/discussion\/95661\/sheet-count","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95661\/sheet-count","format":"Rich","tagIDs":[219],"lastPost":{"discussionID":95661,"commentID":344253,"name":"Re: sheet count?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344253#Comment_344253","dateInserted":"2022-09-21T15:47:09+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\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-21T22:43:03+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":"2022-09-21T15:51:54+00:00","dateAnswered":"2022-09-21T15:47:09+00:00","acceptedAnswers":[{"commentID":344253,"body":"

Hi @Ray of Hope<\/a> <\/p>

I hope you're well and safe!<\/p>

You can see all sheets you own in the Account Administration >> Plan & Billing Info<\/p>

Would that help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-21 15:51:54","updateUser":{"userID":152598,"name":"Ray of Hope","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20of%20Hope","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucpYTh27kmYr-r81E4OkPmSJZFfQThpkGun7LJSz=s96-c","dateLastActive":"2022-09-21T15:50:27+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":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">