使用“Smartsheet1”中链接的单元格数据打开并过滤“Smartsheet2”中的数据

JLawrence

你好,

对Smartsheet非常陌生，所以请耐心听我说。

我想在Smartsheet1中创建一个名字列表(假设是“Alpha, Bravo, Charlie”)，每个名字都是指向smartsheet2的链接。

Smartsheet 2包含一个表，其中列“Names”有各种名称。

在Smartsheet1中单击链接后，它会打开Smartsheet2，并根据所单击的链接过滤“名称”中的数据。

例如，在Smartsheet1中单击“Bravo”，Smartsheet2打开时，只有“Name”列中显示“Bravo”的行可见。

希望这能说得通。如果可能的话，我将不胜感激。

保罗新来的

我建议只在表1上创建过滤器。

JLawrence

I would suggest just creating filters on Sheet 1.<\/p>","bodyRaw":"[{\"insert\":\"I would suggest just creating filters on Sheet 1.\\n\"}]","format":"rich","dateInserted":"2021-11-26T15:29:23+00:00","insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-09-01T20:14:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/311995#Comment_311995","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/311995#Comment_311995

谢谢你的建议，但我正试图以这种非常具体的方式限制可见数据。

这是为了模仿我们目前需要替换的系统。此外，如果可以这样设置，将使事情更容易管理。

如果有可能只允许在同一工作表上的数据被过滤后才能看到，我可能会接受这个建议。

她名叫Stara

嗨@JLawrence

我希望你一切安好!

你有没有尝试过使用高级应用程序动态视图?

这是一种选择吗?

我希望这对你有帮助!

周末愉快，感恩节快乐!

最好的

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

✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成或/和作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!

JLawrence

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

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

Have you explored using the Premium App, Dynamic view?<\/p>

Is that an option? <\/p>

I hope that helps!<\/p>

Have a fantastic weekend & Happy Thanksgiving!<\/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 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>","bodyRaw":"[{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"JLawrence\",\"userID\":142119}}},{\"insert\":\" \\nI hope you're well and safe!\\nHave you explored using the Premium App, Dynamic view?\\nIs that an option? \\nI hope that helps!\\nHave a fantastic weekend & Happy Thanksgiving!\\nBest,\\n\"},{\"attributes\":{\"bold\":true,\"link\":\"mailto:andree@workbold.com\"},\"insert\":\"Andrée Starå\"},{\"insert\":\" | Workflow Consultant \\\/ CEO @ \"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/workbold.com\\\/\"},\"insert\":\"WORK BOLD\"},{\"insert\":\"\\n✅\"},{\"attributes\":{\"italic\":true},\"insert\":\"Did my post(s) help or answer your question or solve your problem? Please support the Community by \"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"marking it Insightful\\\/Vote Up or\\\/and as the accepted answer\"},{\"attributes\":{\"italic\":true},\"insert\":\". It will make it easier for others to find a solution or help to answer!\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2021-11-26T18:04:28+00:00","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-03T14:47:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/312009#Comment_312009","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/312009#Comment_312009

你好@Andree Stara，

这绝对是一个选择，如果它能让我做我需要的。

我从上周开始使用Smartsheet，我不知道要怎样才能让它工作，也不知道要花多少钱。

指针吗?

问候

JLawrence

https:\/\/community.smartsheet.com\/discussion\/comment\/311995#Comment_311995<\/a><\/p>

Thanks for the suggestion, but I'm trying to limit the viewable data in this very specific way.<\/p>

It's to mimic a system that we currently have that needs replacing. Also, it will make things easier to manage if it could be set up this way.<\/p>

If it is possible to only allow data to be seen once filtered if it is on the same sheet, I might be open to that suggestion.<\/p>","bodyRaw":"[{\"insert\":\"https:\\\/\\\/community.smartsheet.com\\\/discussion\\\/comment\\\/311995#Comment_311995\",\"attributes\":{\"link\":\"https:\\\/\\\/community.smartsheet.com\\\/discussion\\\/comment\\\/311995#Comment_311995\"}},{\"insert\":\"\\n\"},{\"insert\":\"Thanks for the suggestion, but I'm trying to limit the viewable data in this very specific way.\\nIt's to mimic a system that we currently have that needs replacing. Also, it will make things easier to manage if it could be set up this way.\\nIf it is possible to only allow data to be seen once filtered if it is on the same sheet, I might be open to that suggestion.\\n\"}]","format":"rich","dateInserted":"2021-11-26T16:06:58+00:00","insertUser":{"userID":142119,"name":"JLawrence","url":"https:\/\/community.smartsheet.com\/profile\/JLawrence","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-12-01T18:09:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/312003#Comment_312003","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/312003#Comment_312003

你好@Paul新来的，

对不起，你看到我的回复了吗?

您是否知道，如果它是在同一工作表上，只允许数据被过滤后看到一次是可能的?

保罗新来的

人们将能够打开和关闭过滤器并选择不同的过滤器，但本质上与单击工作表中的超链接来过滤数据相同。