仅带过滤器的共享表
增强请求:我们公司需要能够与两个或更多的提供商共享工作表,并且由于保密性,我们需要将该信息过滤并锁定在过滤器中,以便他们无法看到一般工作表。但是我们仍然需要提供者能够对带有过滤信息的表单进行更改。
因此,我们需要的是允许您通过锁定过滤器共享工作表的部分内容。
其他人呢?
评论
-
卡洛琳棉花 ✭
我同意
-
罗伯特·卡斯珀 ✭
我们在其他领域也提出了同样的要求。希望这能进入开发队列。
-
休·麦金尼 ✭
夏洛特上周评论过这个话题。
-
布拉德·琼斯 ✭✭✭✭✭✭
这里我还是给它a +1。
真的,这归结为能够更有选择性地展示和分享。而且更安全。
-
这将是一个很棒的功能,也是我正在尝试做的事情。
-
我不得不同意,能够选择过滤器和选择谁分享将是非常有用的。今天我发现这是一个我一直在努力解决的问题。
-
特蕾西Siepser ✭✭✭✭
请把我的投票也加到这个功能上!
-
这将非常有帮助
-
我上周才开始使用SS。我喜欢它。然而,我刚刚遇到了这个问题。对于我管理的有多个供应商的项目,我有一个SS。我想发送每个供应商的项目没有看到其他供应商的项目。他们可以编辑的东西。
我在想,这怎么可能不是一个功能。
我可以为每个供应商创建一个工作表,然后将这些工作表链接到“主”工作表吗?
谢谢,
史密斯
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭
是的。
蜂窝连接的限制是5000个入站链接。根据您拥有的供应商数量(因此也就有了表格),这可能不是适合您的解决方案。
此外,如果您经常添加/修改供应商,将会增加管理负担。
克雷格
-
夏洛蒂伯勒尔 ✭
克雷格,
请详细解释一下。我想知道如何着手做这件事。
谢谢,
夏洛特
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭
没有所有的要求/事实,很难给出一个明确的答案。
这篇关于细胞连接的文章是一个很好的起点。
https://help.smartsheet.com/articles/861579-cell-linking
无论您是否有一个项目与多个供应商或多个项目与多个供应商,我会尝试开始与一个表每个项目。首先,您需要设置它(很可能使用Dependencies)。一旦进入单元格链接,一些项目设置就会碍事(哪些列可以作为目标列)。
对于每个供应商,创建一份工作表的副本(不带数据),然后将项目表中“受控”的单元格(如日期)从项目表链接到供应商表,并将供应商表中“受控”的单元格(如状态、问题等)从供应商表链接到项目表。
为每个供应商重复,最后为每个项目加上每个供应商各一张表格。
如果您与同一供应商有多个项目,您可以使用相同的供应商表或为每个项目制作一个新的供应商表(这取决于您的需求)。
在某些情况下,我会在初始创建主进度表之后关闭依赖性,但这也取决于一些事情——比如进度表预期更改的频率、风险级别,诸如此类。
我希望这对你有帮助。
克雷格
-
酸乳酒 ✭✭
我想给工作表分配一个默认过滤器。否则,可能会共享过多不必要的数据。发布要想更有用,还需要尊重/应用默认视图。
类别
Nested IF formulas read from left to right and stop on the first true value. So if you have In Progress in one child row and On Hold in another child row, it will register a true value with the In Progress argument, output that, then stop evaluating. If you want On Hold to \"override\" In Progress, you would need to adjust the order in which your IFs are nested.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":106419,"type":"question","name":"SUMIFS not working (referencing another sheet)","excerpt":"I'm struggling with getting a SUMIFS function to work properly that is referencing another sheet. So on my sheet with the function, I have it as: =SUMIFS({Total GL Detail Range 4}, {Total GL Detail Range 5}, Project8, {Total GL Detail Range 3}, Title@row) ...where the \"Total GL Detail\" is the other sheet referenced. Range…","categoryID":322,"dateInserted":"2023-06-14T13:17:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T20:49:20+00:00","insertUserID":162357,"insertUser":{"userID":162357,"name":"EBooher","url":"https:\/\/community.smartsheet.com\/profile\/EBooher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:58:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"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":"2023-06-15T01:08:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":15,"countViews":104,"score":null,"hot":3373533417,"url":"https:\/\/community.smartsheet.com\/discussion\/106419\/sumifs-not-working-referencing-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106419\/sumifs-not-working-referencing-another-sheet","format":"Rich","lastPost":{"discussionID":106419,"commentID":380651,"name":"Re: SUMIFS not working (referencing another sheet)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380651#Comment_380651","dateInserted":"2023-06-14T20:49:20+00:00","insertUserID":45516,"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":"2023-06-15T01:08:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T20:08:57+00:00","dateAnswered":"2023-06-14T18:51:01+00:00","acceptedAnswers":[{"commentID":380616,"body":"
Ok. I just had someone else earlier this week have the same issue. Even after converting all of the IDs to text it still wasn't working. Lets try converting everything on the source sheet to numbers. Take that LEFT formula you have that strips the ID out and wrap it in a VALUE function.<\/p>
=VALUE(LEFT(.......................))<\/p>
<\/p>
Then try the COUNTIFS on the ID again, but instead of referencing the helper cell in the formula sheet that we created, reference the linked cell that houses the numerical value.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">