我的智能表愿望清单

24

评论

  • 这真是一次很好的谈话。谢谢你的帮助,梅根。它提供了一个机会,不仅确定我们的“愿望清单”项目的Smartsheet,但相互学习。



  • 瑞秋,

    在多选择列上使用正常的列自动换行格式工具栏选项,选中的选项将自动换行!

    换行多选择列



  • 谢谢你开始这个主题,也谢谢所有为它做出贡献的人。我们将尽我们所能满足您的愿望!我可以为自动化工作流程和对话发言,我已经向我的同事指出了这一点,他们涵盖了应用程序中提到的其他一些领域。

    我们承诺的一些事情,比如在移动行自动化工作流中选择特定列,在移动行之外添加“复制行”,在工作表摘要字段中向联系人发送警报/请求,在复制/移动行中映射特定列,自动工作流对话框的排序,向智能工作表组发送请求/警报,手动触发工作流,评论的反应/喜欢,以及从一个工作表复制到另一个工作表。我不能承诺具体的时间,但我可以说前者比后者更快!

    再次感谢您的反馈。我们收到了很多,而且范围很广,但我们喜欢它,我希望你看到我们正在采取行动!

  • 拉克兰代替
    拉克兰代替 ✭✭✭✭✭✭

    这是两个旧的方法,但是可以极大地改善信息收集:

    1.依赖于表单,因此不显示不相关的字段

    2.提交一个表单并将数据添加到两个单独的表格中(同时,将复制作为移动行自动化/功能的选项添加,然后对这个表格进行排序)

  • @CollabMeganPMP
    @CollabMeganPMP ✭✭✭✭

    谢谢你的回复,Scott!!期待听到更多,当你可以分享!

  • @CollabMeganPMP
    @CollabMeganPMP ✭✭✭✭

    拉克兰-

    我喜欢你的第一个想法——我们需要在表单中加入一点“如果这样,那么那样”的动作——一些逻辑会很好。有一些逻辑可以在动态视图中完成,但不是每个人都有动态视图它不会适合每个用例。

  • 我们致力于允许自动化工作流使用组作为收件人。这不是一回事,但很快您就可以使用Sheet Summary字段作为收件人,这在某些情况下可能会有所帮助。

  • 艾拉
    艾拉 ✭✭✭

    谢谢你,斯科特!真是个好消息,我都等不及了!

    我很好奇是否能够使用工作表摘要字段作为收件人,所以无论何时您可以与我们分享更多,我们将不胜感激!

    谢谢

  • 艾拉
    艾拉 ✭✭✭

    将工作流从一张表复制到另一张表——这是另一个非常有用的功能!谢谢你,斯科特!复制/粘贴或复制工作表中的列呢?

  • 嗨,艾拉,

    在自动化工作流程中复制/粘贴或复制工作表中的列不在我的雷达范围内。你的团队会如何使用它?你能告诉我更多关于流程/工作流程/用例的信息吗?

  • 你应该会在年底前收到我们的更多信息。

    感谢您的反馈和支持!

  • 迈克Wilday
    迈克Wilday ✭✭✭✭✭✭

    我有一个新的,我想很多人会从中受益。报表摘要!!将其添加到增强请求中。

  • 艾拉
    艾拉 ✭✭✭

    你好,斯科特,

    例如,现在我正在为一个项目工作8个不同的表,我需要为这8个表中的每一个添加8个具有相同名称/格式的列。我无法从Excel中导入,因为这些表格中已经有其他列了。除非有其他方法,否则我需要创建列,选择适当的格式,在每个工作表中重新命名它们。在这种情况下,页与页之间的复制/粘贴会非常有用。

    在表-而不是创建一个空白的列,我需要选择适当的格式(文本/数字,下拉等),我可以通过只是复制列和重命名它加快进程。

    谢谢

  • @CollabMeganPMP
    @CollabMeganPMP ✭✭✭✭

    将评论标记为状态摘要…

    如果能够将对话中的评论标记为上下文状态摘要呢?

    我们的工作表中现在有一个字段叫做“状态摘要”。它是一个文本字段,大多数时候只是从对话中的评论中复制/粘贴的信息。这样,我们就可以为我们的高管做一个简单、清晰的状态报告,他们不必通读评论。

    如果有一种方法可以将标记为状态摘要的评论拉到“状态摘要”文本字段中,那将是惊人的!!而且它会节省很多时间(人们也不必记住复制/粘贴)。

  • 保罗新来的
    保罗新来的 ✭✭✭✭✭✭

    在这里是另一个有一些好主意的愿望清单。任何想要笑一笑的人都应该看看下拉式建议的例子……

    第3号这一个是另一个好主意。列出所有挂起的更新请求的报告。

    4号和5号另一个关于更新请求也是个好主意。

    我个人…

    我还想看看@character

    我们有一个@cell它可以查看一个范围并逐个单元计算。如果我们可以查看单元格内的数据并逐个字符地进行评估,那就太好了。

    我还没有弄清楚如何把细节放到足够连贯的思想中来解释,但一般的想法是,单元格中的数据成为我们的范围。

    一旦我想到如何最好地解释它,我就会更新,这样它听起来就不会像一堆漫无边际的废话。哈哈

    thinkspi.com

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

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

There's a known issue at the moment.<\/p>

\n \n https:\/\/status.smartsheet.com\/incidents\/n3gv8nrd6cyf\n <\/a>\n<\/div>


<\/p>

\n \n https:\/\/status.smartsheet.com\/\n <\/a>\n<\/div>

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"},"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":106251,"type":"question","name":"Unable to edit dashboard with Admin rights","excerpt":"Hello all, I have added a user as an admin for a dashboard but she is unable to see the edit (pencil) button. Tried adding her as admin in the workspace but still doesn't work. Any idea? We are on Enterprise plan. Thank you.","categoryID":321,"dateInserted":"2023-06-09T06:08:55+00:00","dateUpdated":"2023-06-09T07:54:11+00:00","dateLastComment":"2023-06-12T13:55:34+00:00","insertUserID":124399,"insertUser":{"userID":124399,"name":"firestorm","url":"https:\/\/community.smartsheet.com\/profile\/firestorm","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!0pnQ_1i5ezw!2uNXv2NG1jQ!_3DRw9ClXTT","dateLastActive":"2023-06-12T07:56:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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-12T15:52:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":65,"score":null,"hot":3372875069,"url":"https:\/\/community.smartsheet.com\/discussion\/106251\/unable-to-edit-dashboard-with-admin-rights","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106251\/unable-to-edit-dashboard-with-admin-rights","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":106251,"commentID":380080,"name":"Re: Unable to edit dashboard with Admin rights","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380080#Comment_380080","dateInserted":"2023-06-12T13:55:34+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-12T15:52:45+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-06-12T08:23:14+00:00","dateAnswered":"2023-06-12T04:13:41+00:00","acceptedAnswers":[{"commentID":380023,"body":"

@firestorm<\/a> <\/p>

Yes, unfortunately, (if I'm not mistaken) a license is needed to be able to edit a Dashboard. <\/p>

The sheet Owner and Admins can add or edit dashboard widgets. A license is required.<\/em><\/p>

More info. <\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/518558-widget-types-for-smartsheet-dashboards\n <\/a>\n<\/div>


<\/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":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":106217,"type":"question","name":"Dynamic View- using multiple contact columns to restrict access","excerpt":"I have a dynamic view that used to give access based on two columns (if you were in the Contact or Back Up Contact - you could see that row). On Tuesday this functionality was no longer working (the page would not load for anyone) and I went in to fix it and had to select the restriction just on one contact column- I…","categoryID":321,"dateInserted":"2023-06-08T17:25:00+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T13:53:09+00:00","insertUserID":135050,"insertUser":{"userID":135050,"name":"Kernesa Samana","url":"https:\/\/community.smartsheet.com\/profile\/Kernesa%20Samana","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HhtBX2V_lvQ!ujlE5-cskro!7uS1l0rsYem","dateLastActive":"2023-06-08T18:29:55+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-12T15:52:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":69,"score":null,"hot":3372826689,"url":"https:\/\/community.smartsheet.com\/discussion\/106217\/dynamic-view-using-multiple-contact-columns-to-restrict-access","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106217\/dynamic-view-using-multiple-contact-columns-to-restrict-access","format":"Rich","lastPost":{"discussionID":106217,"commentID":380078,"name":"Re: Dynamic View- using multiple contact columns to restrict access","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380078#Comment_380078","dateInserted":"2023-06-12T13:53:09+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-12T15:52:45+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-06-08T18:33:36+00:00","dateAnswered":"2023-06-08T18:04:40+00:00","acceptedAnswers":[{"commentID":379680,"body":"

Apply a filter to the sheet and then you can select that filter in the Dynamic View.<\/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":[]}">

使用Smartsheet的趋势