我喜欢这个功能
对于我们的使用来说，如果你在一个工作空间中，比如说有50个工作表，你可以勾选所有的工作表，并使用actions按钮复制所有的工作表，这将是很大的帮助。然后，我可以把这些表格移到另一个文件夹，同时保留需要的数据，删除不需要的数据。我们尝试过模板，但我们的表格变化太频繁，无法跟上模板的步伐。如果有人有解决办法，我洗耳恭听!
评论
-
嗨,蒂芙尼,
当将整个文件夹或整个工作区的表格/报告/仪表板保存为“新”功能成为Smartsheet功能时，我从真正的模板过渡到只有模板工作区，但对象保持各自的形式(表格、报告和仪表板)。
任何用户，包括查看者，都可以右键单击“模板”工作区，并将整个工作区保存为新的，以创建一个新项目。这在保持模板报告和仪表板与表之间的互连性方面也做得很好。
*上面的逻辑适用于文件夹，只要所有的对象都在一个文件夹下面，你想“保存为新”。
希望这对你有帮助!
类别
I hope you're well and safe!<\/p>
Yes, absolutely.<\/p>
Here's the structure.<\/p>
=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0))<\/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>
If you're using dependencies in a Project Sheet, then the Duration column is not able to be updated via formulas <\/a>or cell links. This is because it's used in combination with the Start and Finish dates in your sheet to automatically generate data (e.g. if you add the Start date and a Duration, the Finish date populates. If you add the Start date and Finish date, the Duration automatically populates).<\/p>
Latest from Zapier Support.<\/p>
\"I've submitted this feature request on your behalf. That does a few things:<\/em><\/strong><\/p>
- Bring this to the attention of the integration developers<\/em><\/strong><\/li>
- Help track interest in this feature being implemented<\/em><\/strong><\/li>
- Allows us to notify you via email if this feature becomes available in the future<\/em><\/strong><\/li><\/ul>
While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!<\/em><\/strong><\/p>
Prioritization is largely dependent on the number of customers affected. Issues with only one interested customer will be auto-closed after 3 years.<\/em><\/strong><\/p>
I'm sorry, I wish I had a more immediate solution for you. It never hurts for you to reach out to the app developer directly (Smartsheet in this case) to let them know you're running into an issue with their Zapier integration. We do notify them from our end, but a nudge from their users can sometimes carry more weight!\"<\/em><\/strong><\/p>
--<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":[]}">
