如何自动获取报告文件夹中的所有文件，即使添加了新文件?
我知道我可以单击包含一组工作表的文件夹，它将拉入所有这些工作表，但是当我向文件夹添加新工作表时，我仍然必须在下次打开报告时显式地选择它们以显示它们。是否有一种方法可以自动触发包含，或者我做错了?
答案
-
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
不幸的是，现在还不可能，但这是一个很好的主意!
这里有一个或多个可能的解决方案
- 高级应用程序，控制中心
- 使用工作区，然后报告将自动包含工作区中的所有内容
这些选项会有用吗?
我希望这对你有帮助!
注意安全，祝你度过美好的一周!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成或/和作为公认的答案．这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
KatWoodham ✭✭✭✭✭
我的理解是，文件夹不会自动更新报告(我甚至把东西移到另一个文件夹，工作表也不会退出……)，但工作区会。在我看来，这并不理想。目前，如果我不能将工作空间专门用于报告的这些项目(通常不实际)，那么我会尝试提出逻辑，将过滤到我想要包含在报告中的工作空间中的工作表。不总是可能的，但我通常可以找到一个独特的字段，短语或其他类型的表格上没有的东西。
-
Freymish ✭我提出了一个增强请求，并使用了
- “使用工作区，然后报告将自动包含工作区中的所有内容”
建议作为我的变通办法。
感谢所有!
-
她名叫Stara ✭✭✭✭✭✭
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
帮助文章参考资料欧宝体育app官方888
类别
Hi Deepthi, try this one...<\/p>
=if([Date1]@row < today(), [Date2]@row)<\/p>
Did that help?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-25 22:38:25","updateUser":{"userID":99556,"name":"dsmartsheetuser","url":"https:\/\/community.smartsheet.com\/profile\/dsmartsheetuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-25T22:54:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":96959,"type":"question","name":"Dashboard auto color metrics.","excerpt":"Is there a way to auto color metrics (derived from Smartsheet Summary section) percentages on Dashboard ? EX: If the production rate is over the set goal - auto color the percentage number on dashboard to green if not auto color the percentage to red to indicate below goal ?","categoryID":322,"dateInserted":"2022-10-25T14:43:48+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T00:07:31+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T03:43:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153291,"lastUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T03:43:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3333453079,"url":"https:\/\/community.smartsheet.com\/discussion\/96959\/dashboard-auto-color-metrics","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96959\/dashboard-auto-color-metrics","format":"Rich","lastPost":{"discussionID":96959,"commentID":348641,"name":"Re: Dashboard auto color metrics.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348641#Comment_348641","dateInserted":"2022-10-26T00:07:31+00:00","insertUserID":153291,"insertUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T03:43:44+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":"2022-10-26T00:07:35+00:00","dateAnswered":"2022-10-25T14:59:36+00:00","acceptedAnswers":[{"commentID":348581,"body":"
Can only be done if the metric is coming from a cell (using conditional formatting on the sheet level).<\/p>
This is not available form the sheet Summary<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-26 00:07:35","updateUser":{"userID":153291,"name":"keesuri25","url":"https:\/\/community.smartsheet.com\/profile\/keesuri25","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T03:43:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":96938,"type":"question","name":"Need help with sumifs statement","excerpt":"I am trying to sum a column in a sheet if one of seven cells contain a matching text string. It is bombing out and I am stuck. The last criteria is to limit the invoice amounts summed to those that are overdue (date before today). Formula =SUMIFS({balance}, {A1}, HAS(@cell, \"alia.bostaji@colliers.com\"), OR({a2}, HAS(@cell,…","categoryID":322,"dateInserted":"2022-10-24T19:32:32+00:00","dateUpdated":"2022-10-24T19:35:57+00:00","dateLastComment":"2022-10-25T20:54:42+00:00","insertUserID":121535,"insertUser":{"userID":121535,"name":"Ron Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Ron%20Anderson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!z_dfM0Rnvro!hDvfYbww634!SePTsIm5CpO","dateLastActive":"2022-10-25T20:53:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":121535,"lastUserID":121535,"lastUser":{"userID":121535,"name":"Ron Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Ron%20Anderson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!z_dfM0Rnvro!hDvfYbww634!SePTsIm5CpO","dateLastActive":"2022-10-25T20:53:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":56,"score":null,"hot":3333375434,"url":"https:\/\/community.smartsheet.com\/discussion\/96938\/need-help-with-sumifs-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96938\/need-help-with-sumifs-statement","format":"Rich","lastPost":{"discussionID":96938,"commentID":348622,"name":"Re: Need help with sumifs statement","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348622#Comment_348622","dateInserted":"2022-10-25T20:54:42+00:00","insertUserID":121535,"insertUser":{"userID":121535,"name":"Ron Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Ron%20Anderson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!z_dfM0Rnvro!hDvfYbww634!SePTsIm5CpO","dateLastActive":"2022-10-25T20:53:50+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/468U2K8FCTQT\/picture1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Picture1.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-25T15:13:05+00:00","dateAnswered":"2022-10-25T13:43:21+00:00","acceptedAnswers":[{"commentID":348567,"body":"
